Question

MySQL connection problem need help!

Posted July 29, 2014 2.5k views

Created a database, trying to use it in a script with an installer built in, located at pw.digitera.info on 162.243.75.66 and using the following values;

Hostname - localhost
Database - passworx
Username & password entered precisely

The installer keeps kicking me out of the Databse conenction step, so I’m just checking to see if I am doing anything wrong here. Like, should I be using something else beside localhost for example?

Add a comment
info686413
By:
info686413

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
2 answers
kamaln7 July 29, 2014

Try connecting to MySQL from the CLI:

mysql -h localhost -u passworx -p

It should prompt you for a password. If the credentials are correct, you will see a mysql shell prompt:

mysql>
Reply Report
info292414 July 29, 2014

You should be able to use localhost even if mysqld is listening on your public IP address.

Try to connect to your server via SSH and execute the following command:

mysql -u username -p

Enter the password when prompted and see if it allows the connection. If you get an error such as access denied, then you probably forgot to flush the privileges.

In case the connection fails then mysqld is probably not running. You can check that by executing the following command:

ps x -A | grep mysqld

Reply Report

Looking for something else?

Ask a new question Search for more help