Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: starlogic on February 10, 2004, 12:10:33 AM

Title: MySQL
Post by: starlogic on February 10, 2004, 12:10:33 AM

I am trying to install phpMyAdmin on my SME Server 6.0. It is a fresh install that I just downloaded. I get this error message:

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

Server localhost
Error

MySQL said:


#1045 - Access denied for user: 'root@localhost'

What am I doing wrong? I have followed the instructions. I have installed it before in the past. Any suggestions?

Title: MySQL
Post by: grand-pa on February 10, 2004, 03:34:04 AM

I guess you haven't written the MySQL root password in the config.inc.php file. :hammer:
This password is not the same as the system root/admin password. You can find the 76 characters MySQL root password in /root/.my.cnf 8-)

But for your own use, you should create another local MySQL DBA account and use it instead of the root one (never delete this root account : the system needs it).
To create such an admin account, you can follow these commands :

Quote

[root@sme-60 root]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10799 to server version: 3.23.56

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'new_dba'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> QUIT;

You just have to type what's in blue ans modify what's in red with your values. You can also modify 'localhost' to an IP range or a specific IP address if you need.
Don't forget the semicolons at the end of each line. ;-)