New server Question

[ionhsmith]

I have a UO dedicated server so I thought I would try and EQ one but I am running into errors following the guide on this website. I am on the step
Open a command prompt and type in:-

mysql -uroot

then type in:-

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('your_pasword');

but it tells me cant connect to MySQL server on local host... any suggestions?

so far everything else is going good ... compiled with 0 errors

[Scorpious2k]

It sounds to me like mysql isn't running. You might want to check in the windows task manager and see if mysqld.exe is running in the processes.

I don't know a lot about xampp and I am using MariaDB instead of MySQL...

[ionhsmith]

I don't know much about any of it ... first time using it ... MySQL is now running but now I get Error 1045 (28000): Access denied for user "nroot'@'localhost' (using password:yes)

anyone with xampp /MySQL experience feel free to throw out some pointers lol and thanks

[Scorpious2k]

Try just typing

mysql -u root

[ionhsmith]

I did that and the above error is what I get

[Scorpious2k]

Then it has a password already. Find the my.ini file for mysql and it will have the password among the configuration settings in it.

[ionhsmith]

None that I see in it ... I have even changed the password
in that filw

[Scorpious2k]

You should see something like...

# The following options will be passed to all MySQL clients
[client]
password	= your_password
port		= 3306
socket		= /tmp/mysql.sock

so when you start mysql use

mysql -u root -pyour_password

thats a -p followed by whatever is in the place of your_password in the my.ini file

[ionhsmith]

I did this and it told me
Warning: Using a password on the command line interface can be insecure
ERROR 1045 (28000): Access denied for user 'root'@localhost' (using password: yes)

[joligario]

Originally Posted by ionhsmith

I did this and it told me
Warning: Using a password on the command line interface can be insecure
ERROR 1045 (28000): Access denied for user 'root'@localhost' (using password: yes)

That is just a warning (although correct). You should use: mysql -uroot -p
It will ask you for the password on a separate line.

Do you have the right password for root? Does root have all privileges?

[ionhsmith]

I am just now trying to set it up ... I have followed the server install guide from the forums here but when I go to set up the password like in step 3 (using xampp)
MySQL -uroot it gives me the access denied for user 'root'@'localhost'

Im not sure how to set root privileges that you asked

[Scorpious2k]

I would first shut down mysqld - the mysql service(probably a way with xampp to do this)

Then check the my.ini file and make sure you know EXACTLY what it says the password is - case matters. Also changing the ini file while it is running doen't change it until it restarts.

Restart the mysql service (with xampp)/

Try the mysql -u root -p[password]

if you still have a problem you have a choice of uninstalling and reinstalling it.. or resetting it which is a bit of hacking.

[ionhsmith]

ok seems I got the server working thanks for the help ... but as a server running with 127.0.0.1 how do I make the client work on that address? I tried to do the shortcut but I get a problem with shortcut c:\users\Gamble\Desktop\Everquest\eqgame.exe"patch me' specified in the target box is not valid .... I also tried to download the eqemu launcher but have no idea how to make it point to my server ... any ideas?

[Scorpious2k]

You are actually asking a lot of questions here whether you know it or not... or at least seeking a lot of different answers.

Where is EQ (client) installed? Do you have a shortcut on your desktop?

Are you running your own logon server or using the public one? What exactly is running when you say the server is running? (what windows have what programs running?)

[ionhsmith]

sorry just new to this EMU. Just trying to learn how to connect to my own server instead of one of the ones on here... Right now the world.exe , queryserv.exe, ucs.exe, and 0:sleeping windows are running, I have the patchme thing figured out but all I can connect to are the servers that are from this website. I cannot connect to 127.0.0.1