MySql Permissions

[Guest_imported]

Can anyone please guide me in the right direction...I just installed MySql on my W2K-Pro machine. Apart from scanning the online manuals I can't seem to find out what is the "main or admin" username. I have seen the username "root" but when I try to login via the GUI interface and creating a database it tells me that "access denied root user doesn't have permission". Also I am not a developer and using DreamweaverMX to create the php pages but when I try to select MySql database I get a "405 Method not allowed" thus I can't select any MySql database..Your help appreciated...

 

[sleipnir214]

"405 Method not allowed" sounds to me like a web server error, not a MySQL error. ______________________________________________________________________
TANSTAAFL!

 

[ToeShot]

From the MySQL Files



The default privileges on Windows give all local users full privileges to all databases without specifying a password. To make MySQL more secure, you should set a password for all users and remove the row in the mysql.user table that has Host='localhost' and User=''.

You should also add a password for the root user. The following example starts by removing the anonymous user that can be used by anyone to access the test database, then sets a root user password:

C:\> C:\mysql\bin\mysql mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> QUIT
C:\> C:\mysql\bin\mysqladmin reload
C:\> C:\mysql\bin\mysqladmin -u root password your_password

After you've set the password, if you want to take down the mysqld server, you can do so using this command:

C:\> mysqladmin --user=root --password=your_password shutdown

If you are using the old shareware version of MySQL Version 3.21 under Windows, the above command will fail with an error: parse error near 'SET OPTION password'. The fix is in to upgrade to the current MySQL version, which is freely available.




HTH Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait