Skip to content

Instantly share code, notes, and snippets.

@blackpioter

blackpioter/mysql_CS.sql

Last active May 1, 2025 11:04
Show Gist options
  • Save blackpioter/9fab195ca2d004e1b31bb37e0313f1c9 to your computer and use it in GitHub Desktop.
Save blackpioter/9fab195ca2d004e1b31bb37e0313f1c9 to your computer and use it in GitHub Desktop.
Download ZIP
mysql CS
Raw
mysql_CS.sql
## mysql: show mysql host,user,passwd
SELECT Host,user,password FROM mysql.user WHERE User = "root" ORDER BY (Host="localhost") ASC ;
## mysql: set empty root password
update user set password=PASSWORD("") where User='root';
flush privileges;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment