EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=616)
-   -   MySQL problem (https://www.eqemulator.org/forums/showthread.php?t=13578)

Yzien 05-04-2004 05:22 AM

MySQL problem
 
I need help with createing data base in MySQL.exe everytime i try it CODE: create database eq; it gives me an error saying access not granted on localhost@ any ideas on what the problem might be?

cofruben 05-04-2004 05:43 AM

open mysql.exe and try writing this:

GRANT ALL PRIVILEGES ON *.* TO yourusername@localhost IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

for example:


GRANT ALL PRIVILEGES ON *.* TO test@localhost IDENTIFIED BY '123456' WITH GRANT OPTION;

Yzien 05-04-2004 05:54 AM

hmm
 
it gave me

CODE:

(Using password: NO)

ERROR 1045:



????????IDK????????

mikenune 05-04-2004 06:42 AM

You're not logging in as root.

Start MySQL like this:

Quote:

C:\mysql\bin> mysql -u root
Then you should be able to do what you want.

Yzien 05-06-2004 03:44 AM

thanks
 
that worked thanks a bunch


All times are GMT -4. The time now is 02:32 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.