Dump of mysql Troubleshooting Commands

Home

   
  sudo systemctl status mariadb
  mysql --version
  ss stop mysql
  sudo mysqld_safe --skip-grant-tables &
  mysql -u root
  sudo systemctl status mariadb
  sudo systemctl stop mariadb
  sudo systemctl start mariadb
  sudo systemctl status mariadb.service
  sudo systemctl stop mariadb
  sudo systemctl status mariadb.service
  sudo systemctl stop mariadb-service
  sudo shutdown -r now
  sudo systemctl status mysql
  mysql -u root -p
  sudo systemctl stop mysql
  sudo mysqld_safe --skipo-grant-tables
  mysql -u root
  sudo mysqld_safe --skip-grant-tables &
  mysql -u root
  ss stop mysql
  ss start mysql
  sss mariadb.service
  ss restart mariadb
  ss restart mysql
  ss restart mariadb-service
  sss mariadb.service
  sss mysql
  ss start mysql
  sss mysql
  mysql -u root
  sudo systemctl stop mysql
  sudo systemctl start mysql
  sudo shutdown -r now
  sss mysql
  mysql -u root -p
  ss stop mysql
  ss disable mysql
  sudo dnf remove mysql
  sudo dnf remove mariadb
  clear
  mysql
  sudo dnf install mariadb-service
  sudo dnf clean all
  sudo dnf install mariadb
  history
  ss start mysql
  ss start mariadb
  ss start 
  sudo dnf install mariadb-service
  sudo dnf install mysql-service
  sss mysql
  sss mariadb
  history
  sudo dnf info maridadeb
  sudo dnf info mariadb
  ss start mariadb
  ss start mariadb-service
  sudo shutdown -r now
  sss mysqld
  ss start mysqld
  ss list-unit | grep sql
  ss enable mysqld
  ss enable mysql
  ss enable mariadb
  ss enable mariadb.service
  sudo dnf upgrade mysqld
  sudo dnf upgrade mysql
  sudo dnf upgrade mariadb
  sudo dnf upgrade mariadb-service
  ss enable mariadb
  ss clean
  ss status
  ss status | grep -i sql
  history

Things to try:
mysql.service
mysqlds
mariadb
mariadb.service
mariadb-service


Ok, my problem was service vs server
Here's what worked:

  962  sudo dnf upgrade mariadb-server
  963  sudo dnf install mariadb-server ==> correct
  964  sudo systemctl enable mariadb-server  ==> incorrect.
  965  sudo systemctl enable mariadb  ==> correct
  966  ss start mariadb ==> correct
  966  ss status mariadb ==> correct


Two more steps were required:
    1) - stop mariadb, and start in safe mode (descried above)
       - manually set the root password (described above)
       - start mariadb normally
    2) - rn /usr/bin/mysql_secure_server