Setting MySQL Permissions, Windows XP
Certainly a novice question:
P. 23, 2. of Beginning, PHP, Apache, MySQL states "by default, MYSQL on Windows sets up all users with all privileges."
I installed MySQL 4.0.22 on Windows XP Home, SP1 (NOT SP2, yet) in the default directory, c:\mysql. The installation seemed to work, but in following the tests starting on p., 23 I get access denied errors. These persist even if I turn off Zone Alarm as the session below shows:
The mysql.com site and online manual devote lot's of space to this without telling one what to do.
How do I gain access privileges?
Tom
.................................
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\>c:\mysql\bin\mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.22-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> exit
Bye
C:\>c:\mysql\bin\mysqladmin -u root shutdown
C:\>NET START MySQL
The MySQL service is starting.
The MySQL service was started successfully.
C:\>c:\mysql\bin\mysql mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
C:\>c:\mysql\bin\mysqladmin reload
c:\mysql\bin\mysqladmin: reload failed; error: 'Access denied. You need the
RELOAD privilege for this operation'
............................
|
