MySQL Forums
Forum List  »  Install & Repo

Re: ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
Posted by: Savyn Vydelingum
Date: December 29, 2005 07:44PM

Hi All,

After posting the issue , this is how I fixed the problem.

First...SuSe Distro.

Search for the my.cnf file and add this line after MAX_ALLOWED_PACKET = 1M
(skip-grant-tables)
See below..

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
skip-grant-tables
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M.

Restart MySQL running /etc/init.d/mysql restart using root if you like.

You should now be able to log into MySQL normally.

Do this update to the root user

update user set password = '' where user ='root' and host = 'localhost';

This will set the root password to blank
Restart MySQL

You should be able to log to the database as before and now set you new root Password.

Make sure you set a root password!

Thanks

Savyn

visit www.publicus-solutions.com
Sponsoring Open Source

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.