LAMP/SSH - Cant login to MySQL
I’ve been trying to connect to MySQL but I am unable.
This is how I go about the setup:
0 - I retrieve the MySQL root password in: /root/.digitalocean_password
1 - I set up 2x A records 3x NS records
2 - I out comment the bin-address or change it to 0.0.0.0 in the MySQL config
3 - I log in to MySQL: mysql -u root -p
In step 3 is it normal that any password works?, and not only the one provided by the digital ocean one click service? as the MySQL root password?
4 - Within the MySQL terminal i:
4.1 - CREATE USER ‘myname’@'myip’ IDENTIFIED BY 'password’;
4.2 - GRANT ALL PRIVILEGES ON * . * TO 'myname’@'myip’;
4.3 - FLUSH PRIVILEGES;
4.4 - quit
In step 4, myip is my own IP, right? like '75.252.532.561’?
5 - Open up HeidiSQL and set the settings like:
5.0 Network MariaDB OR MySQL (TCP/IP)
5.1 Hostname / IP = My servers IP
5.2 User = myname
5.3 Password = password
5.4 Port = 3306
I tried restarting MySQL, I tried many different things, but the above I think is the correct way to set it up?.
However, I am unable to login.. there is not set a firewall and I don’t get it.
I’ve read several articles, questions, answers, solutions, etc etc..
I get this error code 10060 with the message Can’t connect to MySQL server on 'myserverip’ (10060)
Can someone please help me out here?