EQEmulator Forums - Granting access

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)

- - Granting access (https://www.eqemulator.org/forums/showthread.php?t=11312)

Karnan

01-10-2004 09:43 PM

Granting access

When i type

Quote:

Type in: GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

I get

Quote:

ERROR 1045: Access denied for user: '@localhost' <Using password: NO>

Anyone have any ideas? :(

Lurker_005

01-10-2004 10:00 PM

should be '%@localhost' not '%'@localhost

Karnan

01-10-2004 10:09 PM

changed it and still got same error.

Karnan

01-10-2004 10:10 PM

Quote:

GRANT ALL PRIVILEGES ON *.* to '%@localhost' IDENTIFIED BY '%';

Thats what it should be right?

Squiffy

01-10-2004 11:03 PM

Did you log in as root? And is % your username and pwd?

Karnan

01-10-2004 11:10 PM

How do i log in as root and is this how it should be..

Quote:

GRANT ALL PRIVILEGES ON *.* to 'username@localhost' IDENTIFIED BY 'password';

Squiffy

01-11-2004 12:31 AM

Code:

mysql -u root mysql

and I THINK you need to drop the quotes around the username bit... and don't forget grant option

Code:

GRANT ALL PRIVILEGES ON *.* to username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;

All times are GMT -4. The time now is 09:37 PM.