On the remote machine echo X telnet -e X 192.168.1.57 3306 Telnet escape character is 'X'. On the server sudo firewall-cmd -permanent -add-port3306/tcp sudo firewall-cmd -reload. port 3306 is not working 0.00/5 (No votes) See more: MySQL from the last day i facing various problem. Works a treat, but when the server is re-booted, it's like I've lost the port setting and need to re-run the commands.Īs a rather new, but competent, sme server convert, how can I get the change to 'stick', or what should I be searching for to find out what to do to make it stick ? At the moment we are utilising a mysql database across a dozen workstations on the lan and myself locally & remotely, but without running the commands after reboot, no one has access across the LAN or remotely. Following another helpful answer on Fedora firewall commands I could open the correct ports. The default MySQL port is 3306, so you should be able to use 3306 as the port for most situations. Comment this out by adding a pound sign so it is 'skip-networking'. If you want to connect directly to your MySQL database or connect another application to your database, you’ll need to know the MySQL port, along with some other information. So I looked for the problem and found a more 'low level' problem: even telnet is not working on one of these Raspberrys. Comment this out by get 4th result adding a pound sign so it is. Look for the setting 'skip-networking' which tells mySQL to block the port 3306. Problem: I can only connect to the mysql database of one of these Raspberrys (using MySQL Workbench). Look for the setting issues skip-networking which tells mySQL to trying block the port 3306. If someone can tell me what I'm doing wrong, or give me a couple of pointers, or point me to where i need to read, it would be greatly appreciated ?Ĭonfig setprop mysqld LocalNetworkingOnly noĬonfig set mysqld service access public status enabled TCPPort 3306įrom the wiki page on sme mysql to access it from port 3306 rather than socket. To fix this, open my.cnf in the xampp folder xamppfiles/etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |