*Problemă/Întrebare: I can't connect to navicat-mysql
This error appear when i try to connect to navicat: http://prntscr.com/rwx3k6 i tried using ssh tunnel but the same error appear aswell: http://prntscr.com/rwx40v . NOTE* I CAN CONNECT TO MYSQL FROM PUTTY USING THE SAME PASSWORD AS I AM USING IN NAVICAT.
Thanks to anyone who will help.
Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server
#SOLVED
Open up the file under 'etc/mysql/my.cnf'
Check for:
port (by default this is 'port = 3306')
bind-address (by default this is 'bind-address = 127.0.0.1'; if you want to open to all then just comment out this line. For my example, I'll say the actual server is on 10.1.1.7)
Now access the MySQL Database on your actual server (say your remote address is 123.123.123.123 at port 3306 as user 'root' and I want to change permissions on database 'dataentry'. Remember to change the IP Address, Port, and database name to your settings)
mysql -u root -p
Enter password: <enter password>
mysql>GRANT ALL ON *.* to root@'123.123.123.123' IDENTIFIED BY 'put-your-password';
mysql>FLUSH PRIVILEGES;
mysql>exit
Open up the file under 'etc/mysql/my.cnf'
Check for:
port (by default this is 'port = 3306')
bind-address (by default this is 'bind-address = 127.0.0.1'; if you want to open to all then just comment out this line. For my example, I'll say the actual server is on 10.1.1.7)
Now access the MySQL Database on your actual server (say your remote address is 123.123.123.123 at port 3306 as user 'root' and I want to change permissions on database 'dataentry'. Remember to change the IP Address, Port, and database name to your settings)
mysql -u root -p
Enter password: <enter password>
mysql>GRANT ALL ON *.* to root@'123.123.123.123' IDENTIFIED BY 'put-your-password';
mysql>FLUSH PRIVILEGES;
mysql>exit
- Ionuţ M.
-

- Mesaje: 2680
- Membru din: 28 Noi 2015, 22:02
- Aprecieri: 170
- Mulţumiri: 12723
- Rezolvări prob.: 2
- Discord: Copiază ID
- Contact:
Arhivat.
Răspunsuri
7 Vizualizări
762
7 Vizualizări
762
Răspunsuri
0 Vizualizări
43
0 Vizualizări
43
Răspunsuri
7 Vizualizări
1045
7 Vizualizări
1045
Răspunsuri
6 Vizualizări
423
6 Vizualizări
423
-
- Informaţie
-
Cine este conectat
Utilizatori ce ce navighează pe acest forum: Semrush [Bot] și 63 vizitatori

