dbTalk Databases Forums  

Help with default password and sign-in

comp.databases.mysql comp.databases.mysql


Discuss Help with default password and sign-in in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
MikeB
 
Posts: n/a

Default Help with default password and sign-in - 02-07-2011 , 04:28 PM






I've forgotten some stuff here and can't find an easy reference.

I have a copy of EasyPHP installed on my computer and it has a SQL
server. I'm having difficulties signing in to it via a command prompt
(Windows).

If I check, it says the server has no password.

Here is the section from my.ini

# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
password = mysql
port = 3306
socket = /tmp/mysql.sock

[mysql]

If I open a command prompt and type "mysql -u:root" I get the following
error:

Quote:
C:\EasyPHP-5.3.3\mysql\bin>mysql -u:root
ERROR 1045 (28000): Access denied for user ':root'@'localhost' (using
password: YES)
If I type it as follows, I get a password prompt, but when I press enter
(for null password) I get the following:

Quote:
C:\EasyPHP-5.3.3\mysql\bin>MySql -u:root -p
Enter password: *
ERROR 1045 (28000): Access denied for user ':root'@'localhost' (using
password: YES)
I'm out of options. I recall I had this issue some months back when last
I worked with MySQL, but this time round I just don't have any luck and
I cannot recall how I resolved this.

Any advice would be greatly appreciated.

Reply With Quote
  #2  
Old   
MikeB
 
Posts: n/a

Default Re: Help with default password and sign-in - 02-07-2011 , 04:31 PM






MikeB wrote:
Quote:
I've forgotten some stuff here and can't find an easy reference.
..

Any advice would be greatly appreciated.

Ugh. Got it.

the syntax is NOT -U: but -u.

sorry I'm a dumbwit.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.