Mysql Maestro

[crippen]

Hi, I'm trying to connect to a mysql database I've created using Cpanel in my TCH account, with a GUI tool called mySQL maestro. The fields I am having trouble figuring out what to enter are:

 

Host name:

Port number:

User name:

Password:

 

From there you select the database and tables. From searching the forums, I gather that the host name should be ftp.mydomain - is that correct? The username would be myusername_dbusername and the password I gave it. This does not seem to be working however. Any suggestions? Thanks!

[TCH-Bruce]

Host name: your-domain.ext

Port: 3306

User: cpanelname_database-user

Password: password

[crippen]

Thanks. How do I assign a password to the db?

[TCH-Bruce]

Sorry, that is the password for the db_user assigned to the db.

 

And the other field is the cpanelname_dbuser

[crippen]

Thanks again Bruce. This is not working, and I am positive my port is open (I can connect using mysql maestro on port 3306 to other servers just fine). Also testing every password I ever use with this account ...

 

Is it possible that remote connections are not set up correctly for my database? I read that this may be a problem with some accounts and a help ticket should be opened.

[TCH-Bruce]

Have you added your IP to the Access Hosts list in mySQL?

[crippen]

Have you added your IP to the Access Hosts list in mySQL?

 

Yes I've done that.

[TCH-Bruce]

Sorry, I am out of ideas.

 

Maybe someone else that has used this program can shed some light on it for you.

[TCH-Don]

Just to make sure a step is not missing,

here is my checklist for using a database

-- databse connect ----

 

Be sure that in MySql you

 

1 - created the database

2 - created a user

3 -added the user to the database (go back to MySql and find the Add user

select the user and database, and then Add user to database)

 

 

Then to connect to the database in a script use:

 

host: localhost

database: yourCpanelName_databaseName

user: yourCpanelName_databaseUser

password: mypassword

 

* Note password is just as the password,

do not add the CpanelName to it.

 

---------------------------