Mysql: Difference between revisions

From Piszczynski
piszczynski>Aleks
(Created page with " == Enable Remote access == Check config file: *sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf Change bind-address from 127.0.0.1 (local host) to 0.0.0.0 to allow all ip addres...")
 
m (3 revisions imported)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
== mySQL commands ==
Restart mySQL service
*sudo systemctl restart mysql
Show databases
*mysql show databases


== Enable Remote access ==
== Enable Remote access ==

Latest revision as of 22:32, 15 November 2023

mySQL commands

Restart mySQL service

  • sudo systemctl restart mysql

Show databases

  • mysql show databases

Enable Remote access

Check config file:

  • sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Change bind-address from 127.0.0.1 (local host) to 0.0.0.0 to allow all ip addresses access