Skip navigation links

MySQL Forums :: Newbie :: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name'


Advanced Search

Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name'
Posted by: Jimmy Pez ()
Date: December 05, 2006 10:38AM

Im having trouble logging in as the root user though -

Ive tried all the steps mentiond above - ill re-do them - copy and paste - then maybe you can help me out

=====

Last login: Tue Dec 5 11:17:28 on ttyp1
Welcome to Darwin!
z043509:~ JP$ /usr/local/mysql/bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 5.0.27-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database newtest;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'newtest'
mysql> -uroot -p
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-uroot -p' at line 1
mysql> -uroot -p
->
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-uroot -p' at line 1
mysql>
mysql> -uroot -p ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-uroot -p' at line 1
mysql> -u root -p jpellizzi;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-u root -p jpellizzi' at line 1
mysql>

======

I cant get it

Options: ReplyQuote


Subject Written By Posted
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' david ca 02/18/2006 05:37AM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' barrett 02/18/2006 07:46AM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' david Gee 02/18/2006 05:20PM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' barrett 02/18/2006 06:10PM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' Bob Field 02/18/2006 06:41PM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' david Gee 02/19/2006 01:19PM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' Jim Pellizzi 12/05/2006 09:49AM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' Bob Field 12/05/2006 10:32AM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' Jimmy Pez 12/05/2006 10:38AM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' Bob Field 12/05/2006 12:34PM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' Jimmy Pez 12/05/2006 12:39PM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' Bob Field 12/05/2006 01:00PM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' Jimmy Pez 12/05/2006 01:34PM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' Ann Findley 01/23/2008 02:32PM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' Jimmy Pez 12/05/2006 10:38AM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' s/w vicky 02/06/2009 05:02AM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' Abhinav Singh 05/29/2008 04:12AM
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name' rrdh ghdghg 04/29/2009 07:20PM


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.