MySQL Questions Asked in Companies

How to allow the user “sonia” to connect to the server from localhost using the password “passwd”. Login as root. Switch to the MySQL db. Give privs. Update privs # mysql -u root -p mysql> use mysql; mysql> grant usage on *.* to sonia@localhost identified by ‘passwd’; mysql> flush privileges; To allow the user “sonia” … Read more

# mysqladmin -u root -p oldpassword newpassword To update the root password in MySQL, you can follow these steps: Log in to MySQL as the root user: bash mysql -u root -p Enter the current root password when prompted. Once logged in, use the following SQL command to update the root password: sql ALTER USER … Read more

# mysqladmin -u root password newpassword If you want to set a root password for MySQL when there is no root password, you can follow these steps: Login to MySQL as the root user (without a password): bash mysql -u root Set a new password for the root user: sql ALTER USER ‘root’@’localhost’ IDENTIFIED BY … Read more

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server # /etc/init.d/mysql stop # mysqld_safe –skip-grant-tables & # mysql -u root mysql> use mysql; mysql> update user set password=PASSWORD(“newrootpassword”) where User=’root’; mysql> flush … Read more

# mysql -u root -p mysql> SET PASSWORD FOR ‘user’@’hostname’ = PASSWORD(‘passwordhere’); mysql> flush privileges; To change a user’s password in MySQL from the MySQL prompt while logged in as the root user, you can use the following steps: Log in to MySQL as the root user: sql mysql -u root -p You will be … Read more