Remote Mysql

TheDreamX · #1 11-10-2002, 07:05 AM

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 · #2 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 · #3 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 · #4 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 · #5 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 · #6 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.