View Single Post
  #18  
Old 10-22-2003, 04:24 AM
DeletedUser
Fire Beetle
 
Join Date: Sep 2002
Posts: 0
Default

  • 1.
Start - Run - CMD
  • 2.
CD c:\mysql\bin
  • 3.
mysql -u root

Quote:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\*>cd c:\mysql\bin

C:\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 244 to server version: 3.23.58-nt

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

mysql>
  • 4. GRANT ALL PRIVILEGES ON eq.* TO mysqlname@localhost IDENTIFIED BY 'mysqlpassword' WITH GRANT OPTION;

Quote:
mysql> GRANT ALL PRIVILEGES ON eq.* TO *user*@localhost IDENTIFIED BY '*pass*' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
  • 5.
Quote:
C:\*>cd c:\mysql\bin

C:\mysql\bin>mysql.exe
ERROR 1045: Access denied for user: 'ODBC@localhost' (Using password: NO)
Edit:

Restart makes everything work
Reply With Quote