LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) (https://www.linuxquestions.org/questions/linux-server-73/error-1045-28000-access-denied-for-user-root%40localhost-using-password-no-669313/)

ShaqDiesel 09-11-2008 04:18 PM

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
 
I have read many threads about this error and none of the solutions have worked for me. I am trying this:
http://anojrs.blogspot.com/2007/11/a...localhost.html

and get this error:
mysqld --skip-grant-tables
080911 13:55:47 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

080911 13:55:47 [ERROR] Aborting

080911 13:55:47 [Note] mysqld: Shutdown complete

# mysql -u root mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I looked into that error: http://www.tech-recipes.com/mysql_tips762.html
but I don't have /etc/my.cnf! I don't have /tmp/mysql.sock or /var/lib/mysql/mysql.sock either. Should I have these files?

Why am I having problems connecting to mysql if it's a fresh install? Thanks.

leandean 09-11-2008 11:49 PM

try mysql -p. Then give the root password. If mysql isn't running, there is no .sock file. It's dynamically created when mysql starts.


All times are GMT -5. The time now is 05:45 AM.