By info686413
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?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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>
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.