BAN - Solms | ||
MySQL and phpMyAdmin
phpMyAdmin is not really required, but is a very usefull tool to manage and view your MySQL databases. Fetch MySQL and phpMyAdmin:
root@ford:/~ # apt-get install mysql-server mysql-client phpmyadmin When the configuration for phpMyAdmin pops up, select reconfiguration for apache2. And select Yes (a bit later) to restart Apache. To forcebly set a password (in case a password is set and you cannot remember), do this first: root@ford:~ # /etc/init.d/mysql stop root@ford:~ # mysqld_safe --skip-grant-tables &Set a password for the MySQL rootuser (if not already done so): root@ford:~ # mysql -u root mysql mysql> UPDATE user SET Password=PASSWORD('sqlpassword') WHERE user='root'; mysql> FLUSH PRIVILEGES; mysql> quit To check all this browse to http://<ip-address>/phpmyadmin using root and sqlpassword, result should be something like this: Finished. |
Last modified: 2009-10-13 |