Mysql server: erinevus redaktsioonide vahel
Allikas: Kuutõrvaja
Mine navigeerimisribaleMine otsikasti
Resümee puudub |
Resümee puudub |
||
| 28. rida: | 28. rida: | ||
/usr/local/bin/mysqladmin -u root password 'parool234' | /usr/local/bin/mysqladmin -u root password 'parool234' | ||
/usr/local/bin/mysqladmin -u root -h katse 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 | |||
Redaktsioon: 6. veebruar 2007, kell 13: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
