Erinevus lehekülje "Mysql server" redaktsioonide vahel
Allikas: Kuutõrvaja
| 40. rida: | 40. rida: | ||
Your MySQL connection id is 4 | Your MySQL connection id is 4 | ||
Server version: 5.1.15-beta FreeBSD port: mysql-server-5.1.15 | Server version: 5.1.15-beta FreeBSD port: mysql-server-5.1.15 | ||
| − | + | ||
Type 'help;' or '\h' for help. Type '\c' to clear the buffer. | Type 'help;' or '\h' for help. Type '\c' to clear the buffer. | ||
| − | + | ||
mysql> | mysql> | ||
Redaktsioon: 6. veebruar 2007, kell 16:52
Sissejuhatus
Install
cd /usr/ports/databases/mysql51-server make install clean
Seadistus
/etc/rc.conf
rida
mysql_enable="YES"
installime default baasi ja seadistame õigused kuna vaikimisi tekib see root omandusse
/usr/local/bin/mysql_install_db chown -R mysql:mysql /var/db/mysql
strdime mysql serveri
/usr/local/etc/rc.d/mysql-server start
Ning seejärel seadistame root parooli
/usr/local/bin/mysqladmin -u root password 'parool234' /usr/local/bin/mysqladmin -u root -h katse password 'parool234'
testimine
# mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.1.15-beta FreeBSD port: mysql-server-5.1.15 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>
Lõppsõna
Edasi võib juba paigaldada apache ning phpMyAdmin'i edasiseks tööks http://www.phpmyadmin.net/home_page/index.php
