Log in

View Full Version : How to use MySQL? (Question about it)


Magicloud
05-03-2003, 05:35 AM
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"?