EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   How to use MySQL? (Question about it) (https://www.eqemulator.org/forums/showthread.php?t=7009)

Magicloud 05-03-2003 05:35 AM

How to use MySQL? (Question about it)
 
Following the Help Part 2, I setuped the EQEmu, but after I installed (unzip?) MySQL, and copyed the db.sql, ran winmysqladmin.exe, set username / password.

Then ran mysql.exe, but when I "create database eq;", it says "ERROR 1044: Access denied for user: '@127.0.0.1' to database 'eq'",
if I type "create database eq.sql;", it says "ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '.sql' at lin
e 1"

What should I do? (I use mysql 4.1.0-alpha)

Magicloud 05-03-2003 12:40 PM

Solved this by using an older version of MySQL.

While I got a new problem, the "world.exe" can not connect to the database, I have had my SQL Service run, and set the db.ini as the Help Part 2.

And I tryed this: GRANT ALL PRIVILEGES ON eq.* TO xxx@localhost IDENTIFIED BY 'xxx' WITH GRANT OPTION;
MySQL show an Error 1044 to me.

What should I do?

Magicloud 05-03-2003 01:01 PM

And where is the "minilogin.exe"?


All times are GMT -4. The time now is 04:56 PM.

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