Password set for root user in MySQL
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
When failed to start MariaDB database server (Solution - Again Installation)
In the tutorial you should install mariadb-server in place of mysql-server. sudo apt purge mysql* sudo apt purge mariadb* sudo apt autoremove sudo apt autoclean Check if still something in the system : dpkg -l | grep -e mysql -e mariadb if the list is empty then install mariadb server : sudo apt install mariadb-server Now try to check status on stop and start the database : Status after install : sudo systemctl status mysql.service ● mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: active (running) since Wed 2018-03-21 16:08:49 CET; 2min 1s ago Main PID: 15699 (mysqld) Status: "Taking your SQL requests now..." CGroup: /system.slice/mariadb.service └─15699 /usr/sbin/mysqld .../.. Check the PID : sudo more /var/run/mysqld/mysqld.pid 15699 Stop the database : su...
Comments
Post a Comment