Changes between Version 3 and Version 4 of Docs/825gen2/Dev/Database/MySQL

Timestamp:

11/10/23 09:42:34 (2 years ago)

Author:

Don Wilson

Comment:

--

Docs/825gen2/Dev/Database/MySQL

@@ -154 +154 @@
 nano /etc/my.cnf
 }}}
+
+{{{
+[client]
+#password                                       = password
+port                                            = 3306
+socket                                          = /var/lib/mysql/mysql.sock
+
+[mysqld_safe]
+
+[mysqld]
+user                                            = mysql
+port                                            = 3306
+socket                                          = /var/lib/mysql/mysql.sock
+pid-file                                        = /var/lib/mysql/mysqld.pid
+log-error                                       = /var/log/mysqld.log
+basedir                                         = /usr
+datadir                                         = /var/lib/mysql
+skip-external-locking
+skip-networking
+ignore-builtin-innodb
+default-storage-engine                          = myisam
+bind-address                                    = localhost
+
+#
+# include all files from the config directory
+#
+!includedir /etc/my.cnf.d
+}}}
+
+
+Change bind-address from 127.0.0.1 to 0.0.0.0 to allow connections from any IP.
+Insert # symbol in front of skip-networking to comment this out.
+
+Ctrl-X and Y to save file.
+
+Restart MySQL
+
+{{{
+sudo systemctl restart mysqld
+}}}
+
+Verify that MySQL is listening on port 3306
+
+