Setting up a root user in MySQL/MariaDB
CREATE USER ‘admin’@’%’ IDENTIFIED BY ‘mysecretpassword’; GRANT ALL PRIVILEGES ON *.* TO ‘admin’@’%’ WITH GRANT OPTION; FLUSH PRIVILEGES;
Continue reading »Category: MySQL
Setting up MYSQL, Apache2 and WordPress
MySQL/MariaDB Remember to change bind-address to 0.0.0.0. By default it is set to 127.0.0.1 and then you can’t connect remotely! Exactly which config file it […]
Continue reading »Moving the MySQL data directory
Has this happened to you? You run for a while on the default installation of MySQL. The data increases and suddenly you realize that the […]
Continue reading »