MySQL new db error (permission denied)
Hello all, and thanks in advance for your help.
I am fairly new to linux, but I have been thrust into a network admin role where I now manage a FreeBSD webserver.
I use Webmin to manage most of the things on this machine and I am having a problem with MySQL.
There is a mysql user setup on the system and I used that user to loging the mysql module on Webmin. I can log in fine (although even though there is a password setup for the user mysql on the system, to get into the Webmin MySQL module it will only allow me to login in if I leave the password field blank)
Anyway, when I try to create a new database, look at the exsisting ‘test’ db permissions, table permission or field permissions etc I get the following error message:
“Failed to create database : DBI connect failed : Access denied for user: ‘@localhost’ to database ‘mysql'”
What is going wrong?? The ‘@localhost’ part looks like Webmin is not using a user to login to the MySQL program even though I login to the Webmin MySQL module with the mysql user (minus password as stated above)
Please help, I have looked everywhere for an answer to this issue. Thanks.
PS. And remeber I am new to linux and freebsd commands etc. Thanks again!