find ./ -type f -name '*source-string*'

MySql Administration

# ---------------------------------------------------------
# ---    : MySql with SSH tunel
#        https://www.digitalocean.com/community/questions/how-do-i-use-ssh-to-access-mysql-remotely
ssh [email protected] -L 2206:localhost:3306 -N &
#
mysql -h localhost -P 2206 -u user -p
# ---------------------------------------------------------
# ---------------------------------------------------------
# ---    :
#
# Ubuntu / Debian 
/etc/init.d/mysql stop 
# CentOS / Fedora / RHEL 
/etc/init.d/mysqld stop
# Next we need to start MySQL in safe mode 
mysqld_safe --skip-grant-tables &
#
mysql -u root
# Next, instruct MySQL which database to use:
use mysql;
#
mysql> update user set password=PASSWORD("mynewpassword") where User='root';
mysql> flush privileges;
mysql> quit
# Ubuntu / Debian
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
# CentOS / Fedora / RHEL
sudo /etc/init.d/mysqld stop
sudo /etc/init.d/mysql start
# Test the new password by logging in:
mysql -u root -p


Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert.