dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

#1045 - access denied for user 'root'@'localhost' (using password: no) - mysql

This is a discussion on #1045 - access denied for user 'root'@'localhost' (using password: no) - mysql ; #1045 - access denied for user 'root'@'localhost' (using password: no) I am having trouble setting up MySql. I've installed it step by step and run mysql_install_db, but I'm having trouble connecting as root user. I am able to connect as ...


Home > Database Forum > Other Databases > mysql > #1045 - access denied for user 'root'@'localhost' (using password: no)

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 08-13-2009, 03:18 PM
administrator's Avatar
Administrator
  
Join Date: Apr 2006
Posts: 19
administrator has disabled reputation
Default #1045 - access denied for user 'root'@'localhost' (using password: no)
#1045 - access denied for user 'root'@'localhost' (using password: no)

I am having trouble setting up MySql. I've installed it step by step and run mysql_install_db, but I'm having trouble connecting as root user. I am able to connect as a normal user but unable to connect as root user and getting a MYSQL #1045

#1045 - access denied for user 'root'@'localhost' (using password: no)

Reply With Quote
  #2  
Old 08-13-2009, 03:21 PM
administrator's Avatar
Administrator
  
Join Date: Apr 2006
Posts: 19
administrator has disabled reputation
Default Re: #1045 - access denied for user 'root'@'localhost' (using password: no)
Your error indicates that you are not supplying the password to the program. When installing mysql you would have set a root password for accessing mysql and you should pass that password when using the mysql program.

example : mysql -u root -p

Then the system will prompt you for a password and you will no longer receive the Re: #1045 - access denied for user 'root'@'localhost' (using password: no) error
Reply With Quote
Reply

Tags
#1045, mysql

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads

Thread Thread Starter Forum Replies Last Post
Need help w/.ksh script to REORCHK & output Recommended tables to a file Database Administrator ibm-db2 19 06-18-2008 07:19 PM
How is possible that avg_data_blocks_per_key = 0 even with freshstatistics ? Database Administrator Oracle Server 34 12-14-2007 09:54 AM
Insert-Select much slower than same select on its own Database Administrator Oracle Server 21 09-01-2006 07:03 AM
Help interpreting TKPROF output Database Administrator Oracle Server 14 11-10-2003 12:58 AM
Help interpreting TKPROF output Database Administrator Oracle Server 24 11-09-2003 03:00 PM


All times are GMT -4. The time now is 07:07 PM.