Hi Folks
I've been having some problems with phpMyAdmin (PMA) since I set the server up. I had issues installing RPM due to some bad mirror entries in my config files, but even after I set a root password, I didn't have the option to create databases.
I then went into /root/.my.cnf and took the " " away from the root username and password, which actually gave me the option to create databases in PMA, but I still get the same error ;
I can create databases and users under the cpanel MySQL admin, just not from PMA.
can anyone shed some insight into this?
cAosity 2.0
Dual EM64T Xeon 2.8Ghz
1Gb Ram
2 x 250Gb SATA in RAID1
Thanks
I've been having some problems with phpMyAdmin (PMA) since I set the server up. I had issues installing RPM due to some bad mirror entries in my config files, but even after I set a root password, I didn't have the option to create databases.
I then went into /root/.my.cnf and took the " " away from the root username and password, which actually gave me the option to create databases in PMA, but I still get the same error ;
Code:
Error
SQL-query:
CREATE DATABASE `test123` ;
MySQL said:
#1044 - Access denied for user: '[email protected]' to database 'test123'can anyone shed some insight into this?
cAosity 2.0
Dual EM64T Xeon 2.8Ghz
1Gb Ram
2 x 250Gb SATA in RAID1
Thanks