EQEmulator Forums - Remote Mysql

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - Remote Mysql (https://www.eqemulator.org/forums/showthread.php?t=3812)

TheDreamX

11-10-2002 07:05 AM

Remote Mysql

Alright, I've been trying to make a permanent server (the actual PC) to leave on 24/7 for my own server, but it doesn't look like it will be happening anytime soon. So now I want to run my mysql database on my website, dentondesigns.com. I loaded up all the DB files and updates on the site, created a user (TheDreamX), and tried logging on through the emu. It always gives me an access denied error. I read somewhere to type the "give priviliges *.*" or something like that, but then it said I could not run that command because access was denied again. My site uses phpMyAdmin 2.3.2. Please help.

Trumpcard

11-10-2002 09:12 AM

You need to log onto mysql as a root level user, ie one that has permissions to create databases..

TheDreamX

11-10-2002 12:13 PM

Only problem is, I am logged on as the administration user. Does anyone know how else I can have a mysql database running away from my PC?

Trumpcard

11-10-2002 02:36 PM

If you were the root/admin user, you would never see 'permission denied'

Can you do a

mysql>create database testing;

If you get a permission denied, then you need a user with admin rights to adjust privileges..

TheDreamX

11-11-2002 05:12 AM

Yes, I can do the create database command. It's really screwy, do I'm just gonna run it off my PC. Thanks anyways.

Xarslik

11-12-2002 09:09 AM

try this:

Code:

GRANT ALL ON *.* TO TheDreamX@YOUR_IP IDENTIFIED BY 'yourpass';

Make sure to replace YOUR_IP with your actual IP.

All times are GMT -4. The time now is 08:45 AM.