What is my root password for MySQL?

What is my root password for MySQL?

  • If the server was auto provisioned with MySQL then the root password is the same as the server root password.
  • If you have Plesk auto provisioned on your server, then use "admin" and the admin password for Plesk.
  • If you installed MySQL through source, RPM, or up2date, then the initial root account passwords are empty, so anyone can connect to the MySQL server as root - without a password - and be granted all privileges. Unless you set the root password during or after the MySQL installation
    		•

      • Related Articles

      • How to reset a mySQL password?

        If you have lost your root user password for MySQL, you can reset it with the following procedure: Take down the mysqld server by sending a kill (not kill -9) to the mysqld server. The pid is stored in a .pid file, which is normally in the MySQL ...

      • Securing MySQL

        Due to differing needs and requirements this is difficult to answer except on a case by case basis. The MySQL website has a section regarding general security of a MySQL database available here: http://dev.mysql.com/doc/refman/5.0/en/security.html ...

      • Mysql Basic Commands

        [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the sql server. create database [databasename]; List all databases on the sql server. show databases; Switch to a database. use [db name]; To see all the tables in the db. show tables; ...

      • How can I monitor what my MySQL server is doing?

        A handy little Linux application called mytop fits this just perfectly. This is a near-time monitor just like the UNIX utility 'top' that specifically looks at what the MySQL server is doing. It updates every few seconds so you can get a reasonable ...

      • How to install Mysql

        How to install Mysql Via RPM : Please check the following link and get RPM http://httpupdate.cpanel.net/mysqlinstall/ in above list (not rpm) click on the version for which you want to install mysql than click on the operation system than on the ...