MySQL connection problems

[BlueHi]

Hello all,
I am having problems connecting world to mysql. In the pictures you can see that I have granted permission. I had a previous version of mysql version 3.23.58 which stopped working for some odd reason so I loaded this newer version in attempt to fix this problem. I don

[Cisyouc]

maybe try removing the ' from localhost when you grant all permissions? Don't know if that will fix it but i never did it with em ^.^

[BlueHi]

Hello Cisyouc,
Thank you for your reply, I have already tried it without them and it doesn't make a difference. :(

If it didn't work with root then I don't think it will work no matter how many times I grant permission. I am starting to think maybe I just need to recompile. When I compiled the source I used a different mysql folder then my current one for the included files. I am not real sure if that makes a difference but maybe it does?

--- Nope doesn't make any difference my backup of my previous eqemu that worked can no longer connect to MySQL either.

thanks for your reply Cisyouc.
BlueHi

[m0oni9]

I am kind of confused. You are trying to use the database 'mysql' for your emu database? I think you should be creating a new database, then granting access to that.

Also, something I did not notice in the screenshots is if, after you logged in as 'world', if you attempted to switch to your database and do various queries on it. Maybe emu is logging in successfully, but then dying when it queries?

[BlueHi]

Hi m0oni9,
I am not trying to run eqemu on the database mysql, I am just trying to get it to see that it is there before I go writing to the database. Otherwise I would have re-written to the database 100 times to figure this thing out. Also I have made the eqemu database a dozen times and granted permissions but still have the same problem. I noticed when using my ip address instead of local host it then says the username or password is incorrect at the end instead of to many connections. I even set the permissions for my ip address instead of localhost and got the same response. I am really confused here. I have a few more ideas and things that I can try.

I am able to query the database when logged in as world also. If you mean maybe it is just dieing because the data is not in the mysql database, then this is not the case (I don

[cavedude]

The default mysql database is NOT an eqemu database, so therefore you can't use it, even to test. I just tried it real quick here as a test and I got the same errors. You need to build a database with all the proper emu tables and columns first otherwise world is gonna complain.

[ajb20]

You said you upgraded MySQL? I tried that once too and low and behold none of the other versions of MySQL work except the one they use in the installation tutorial. Perhaps try downgrading to the recommended version of mysql.

[sotonin]

naw. the latest MYSQL works fine man. I use it.

[RangerDown]

Your MySQL folder should have an error log file that MySQL keeps for writing severe errors. Usually ends in .err. See if it has anything of interest.

[BlueHi]

Hello all,
I appreciate your help. I created a database populated it with 5.7 and updated it with the changes from cvs. If I don