Erinevus lehekülje "Mysql server" redaktsioonide vahel
Allikas: Kuutõrvaja
| 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 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
