General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
MySQL/Webmin access problem
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!