Posts

Showing posts from September, 2019

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 : sudo systemctl stop mysql.service sudo systemctl status mysql.service ● ma

Create User for phpMyAdmin (MySQL)

1. sudo mysql -p -u root 2. CREATE USER 'pmauser'@'%' IDENTIFIED BY 'password_here'; 3. GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'%' WITH GRANT OPTION;