469,299 Members | 2,050 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

help mysql - cant do anything

Im rather new to Linux and my server has been running great, up until the
other day.

I was messing around with mysql through webmin in mandrake 9.2 and know I
cant do anything, not even create a database. I keep getting this message (
DBI connect failed : Access denied for user: '@localhost' to database
'mysql')
and have no clue how to fix it. I have tried to reinstall the rpms that came
on the mandrake 9.2 cds and I still get the same messages.

If anyone could help it would be greatly appreciated

thanks

Bill Friend
bf*****@wi.rr.com
Jul 20 '05 #1
2 1930
William Friend wrote:
DBI connect failed : Access denied for user: '@localhost' to database
'mysql')


You are trying to create a database with a user '' which dosn't have
prileges to create databases. By default, only 'root' has this privilege.

Try logging in as a root user.

mysql -u root

Or if you have password for root (mysql root is different from Linux
root and they don't share the password)

mysql -u root -p

If this fails, you can try resetting the password for root and try again.
Jul 20 '05 #2
Like they say in electronics trouble-shooting:

"Do some swapping"

Get to another machine and install and get MySQL running on a Windows
machine. If that works, then you know Mandrake OS (I don't know much
about Unix/Linux) is preventing you from accessing your hard drive.
Maybe security or accesss issues???
Good Luck!
"William Friend" <bf*****@wi.rr.com> wrote in message news:<Z5*****************@twister.rdc-kc.rr.com>...
Im rather new to Linux and my server has been running great, up until the
other day.

I was messing around with mysql through webmin in mandrake 9.2 and know I
cant do anything, not even create a database. I keep getting this message (
DBI connect failed : Access denied for user: '@localhost' to database
'mysql')
and have no clue how to fix it. I have tried to reinstall the rpms that came
on the mandrake 9.2 cds and I still get the same messages.

If anyone could help it would be greatly appreciated

thanks

Bill Friend
bf*****@wi.rr.com

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by john townsley | last post: by
3 posts views Thread by john townsley | last post: by
6 posts views Thread by ancelotp | last post: by
17 posts views Thread by so many sites so little time | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.