Mysql: Difference between revisions

From Piszczynski
piszczynski>Aleks
No edit summary
m (3 revisions imported)
 
(One intermediate revision by one other user not shown)
Line 3: Line 3:
Restart mySQL service
Restart mySQL service
*sudo systemctl restart mysql
*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