Changes

From SME Server
Jump to navigationJump to search

Software Collections:MySQL55 (view source)

Revision as of 07:33, 16 February 2017

729 bytes added ,  07:33, 16 February 2017
→‎command line
Line 29: Line 29:     
  /opt/rh/mysql55/root/usr/bin/mysql  --socket=/var/lib/mysql/mysql55.sock
 
  /opt/rh/mysql55/root/usr/bin/mysql  --socket=/var/lib/mysql/mysql55.sock
 +
 +
== Resetting the MySQL root password ==
 +
 +
To reset the password for the MySQL root account. The MySQL root user on SME Server has a random generated password which is generated during installation. You do not need to know this password to login to MySQL with root privileges on SME Server. If you might have changed the MySQL root password you can reset it like this after getting command line access as root user.
 +
service mysql55-mysqld stop
 +
expand-template /root/.my.cnf
 +
expand-template /var/service/mysql55-mysqld/set.password
 +
/opt/rh/mysql55/root/usr/libexec/mysqld --socket=/var/lib/mysql/mysql55.sock --bootstrap --user=mysql --skip-grant-tables < /var/service/mysql55-mysqld/set.password
 +
service mysql55-mysqld start
    
== Use in phpmyadmin==
 
== Use in phpmyadmin==
Unnilennium
Super Admin, Wiki & Docs Team, Bureaucrats, Interface administrators, Administrators
3,240

edits

Retrieved from "https://wiki.koozali.org/Special:MobileDiff/32729"

Navigation menu