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.