Hi there,
I was trying to modify webmin to enable me to use it to manage mysql and I
think I might have modified the root password.
I've now spent about 3 hours trawling through the archives and trying all
sorts of things, but whatever I do I cannot get into mysql as root (I've
attached sample errors at the end).
I'm currently running with --skip-grant-tables, but I still cannot access
mysql
I'd _really_ appreciate some help here as it's a lovely Saturday afternoon
at 15:35 here, and I don't want to be here!
Many thanks in advance to whoever can shed some light on these problems,
Regards,
Derek...
Example errors:
[root@linuxdev bin]# mysql mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
[root@linuxdev bin]# mysql -u root mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
[root@linuxdev bin]# mysql -u root -pxxxxxx mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
[root@linuxdev bin]# mysql -h linuxdev.foreshore.net mysql
ERROR 1044: Access denied for user: '@linuxdev.foreshore.net' to database
'mysql'
[root@linuxdev bin]# mysql -h linuxdev.foreshore.net -u root mysql
ERROR 1044: Access denied for user: '@linuxdev.foreshore.net' to database
'mysql'
[root@linuxdev bin]# mysql -h linuxdev.foreshore.net -uroot mysql
ERROR 1044: Access denied for user: '@linuxdev.foreshore.net' to database
'mysql'
[root@linuxdev bin]# mysql -h linuxdev.foreshore.net -u root -pxxxxxx mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
***************************************************************************************
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of Foreshore Limited.
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
