Category Archives: Database MySQL or MariaDB

connect to mysql remotly

  mysql -uroot -h10.0.0.78 -p # netstat -tupan GRANT ALL PRIVILEGES ON *.* TO ‘USERNAME’@’1.2.3.4’ IDENTIFIED BY ‘PASSWORD’ WITH GRANT OPTION;

Posted in Database MySQL or MariaDB | Leave a comment

MySQL MariaDB – Resetting a lost MySQL root password

Stop MySQL Ubuntu,  Debian /etc/init.d/mysql stop  CentOS, Fedora, and RHEL /etc/init.d/mysqld stop CentOS 7 systemctl stop mariadb.service check if mysql or mysql_safe is running ps -e | grep mysql Safe mode sudo mysqld_safe –skip-grant-tables –skip-networking & Login mysql -uroot .>use mysql; … Continue reading

Posted in Database MySQL or MariaDB | Leave a comment