Some Common MySQL Commands
· ☕ 1 min read
1. Passwordless Login Edit /etc/my.cnf and add a line under [mysqld]: skip-grant-tables=1 Restart the mysqld service 1 systemctl restart mysqld Log in to MySQL as the root user 1 mysql -u root 2. Allow All Access Sources Log in to MySQL 1 mysql -u root -p At the MySQL interactive command line, enter: