shaf2k Posted February 28, 2004 Posted February 28, 2004 i just recently bought a plan on TCH, and i'm trying to use a 3rd party to software to connect to my mysql database, but i'm not sure of the parameters, eg hostname and port # to connect. can someone help me out pls. Quote
MikeJ Posted February 28, 2004 Posted February 28, 2004 Are you trying to connect from a remote system? If so, it's your domain name, and port 3306. If you are connecting from your account, then 127.0.0.1, port 3306. Or you can use /tmp/mysql.sock. Quote
bytesurfer Posted March 5, 2004 Posted March 5, 2004 I am trying to connect to MySQL from a remote system, my home comuter, using Navicat. I have entered the default port 3306, my Hostname, my username for my host, and the password that goes with the username. I also tried using the IP address also for my domain. But still I get an error message saying "Access denied for user: 'myname@myhomeip' (Using password YES). What am I doing wrong here? I have defined some users in the Database, and even tried using those to login. Thanks. Martin Quote
borfast Posted March 5, 2004 Posted March 5, 2004 (edited) You have to define which hosts your users can login from. Also, keep in mind that database names and usernames are in the form of cpanelusername_dbname and cpanelusername_dbusername, respectively. Edited March 5, 2004 by TCH-Raul Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.