Results 1 to 7 of 7
Thread: MySQL remote access
-
10-03-2006, 03:44 PM #1WHT Addict
- Join Date
- Mar 2006
- Posts
- 160
MySQL remote access
Hello,
I need the command(s) to enable MySQL remote access for root for ALL tables.
Also for some reason I can't find my.cnf:
find: my.cnf: No such file or directory
Thanks,
Tom
-
10-03-2006, 04:46 PM #2Junior Guru Wannabe
- Join Date
- Dec 2005
- Posts
- 82
I posted it a few posts below
GRANT ALL ON * TO 'root'@'your_host' IDENTIFIED BY 'your_password';
FLUSH PRIVILEGES;
By default my.cnf doesn't exist. you can create it by yourself and place into your user folder on your server. (in your case it the the root folder /root )
-
10-04-2006, 02:06 AM #3WHT Addict
- Join Date
- Mar 2006
- Posts
- 160
Originally Posted by ngsupb
After running the commands following the idea of replacing you_host with my IP, I still cannot connect remotly. The server is a dedicated MySQL box so I need to be able to remotly connect to it! I am trying to use Navicat to manage the MySQL database server but I keep getting:
1130 - Host '******.ipt.aol.com' is not allowed to connect to this MySQL serverLast edited by Tomdarkness; 10-04-2006 at 02:13 AM.
-
10-04-2006, 02:39 AM #4WHT Addict
- Join Date
- Mar 2006
- Posts
- 160
Originally Posted by Tomdarkness
-
10-04-2006, 02:41 AM #5Retired Moderator
- Join Date
- Feb 2005
- Location
- Australia
- Posts
- 5,849
your_host should be the host you're trying to connect from, ie. ******.ipt.aol.com (or that IP).
You might also want to look into tunnelling your mysql connection through ssh.Chris
"Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them." - Laurence J. Peter
-
10-04-2006, 03:11 AM #6WHT Addict
- Join Date
- Mar 2006
- Posts
- 160
Originally Posted by foobic
-
10-04-2006, 03:28 AM #7Web Hosting Guru
- Join Date
- Dec 2003
- Location
- Pakistan
- Posts
- 344
You should replace 'your_host' with '%' which would enable root to connect to MySQL from any location.
Never forget to execute 'FLUSH PRIVILEGES;' command after updating the record.Muhammad Waseem
Inspedium Corporation (Pvt) Ltd.
InsPanel - Hosting Control Panel for Windows 2000/2003