MySQL

From Wasya Wiki
Revision as of 20:27, 3 September 2018 by Piousbox (Talk | contribs)

Jump to: navigation, search

Don't forget to change bind_ip in /etc/mysql/my.cfg to 0.0.0.0!

Allow root to login from anywhere. From: http://stackoverflow.com/questions/11223235/mysql-root-access-from-all-hosts

CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

With Docker

From: https://hub.docker.com/_/mysql/

docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag

where some-mysql is the name you want to assign to your container, my-secret-pw is the password to be set for the MySQL root user and tag is the tag specifying the MySQL version you want. See the list above for relevant tags.