Remote Mysql

[TheDreamX]

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]

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

[TheDreamX]

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]

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]

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]

try this:


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


Make sure to replace YOUR_IP with your actual IP.