DbSchema Database Designer

DbSchema | MySQL - What is the Default Username and Password?

Publish on DbSchema Blog >>>

The default user for MySQL is __root` and by default it has no password.

If you set a password for MySQL and you can’t recall it, you can always reset it and choose another one.


  1. Make sure that MySQL Server is not running. Open Task Manager, search for the MySQL process and force stop it.

  2. Create a new text file that will contain the statement below:

     SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');

    Replace the password with the new one

  3. Save the file with the __mysql-init name in __C:. The path should look like this:

  4. Open the Start menu, enter Run then write cmd to open the command prompt

  5. Go to the MySQL server __bin` folder

     cd "C:\Program Files\MySQL\MySQL Server 5.6\bin"

    If you installed MySQL with a different path, adjust the __cd`

  6. Run it with the __mysql-init` file

     mysqld --init-file=C:\\mysql-init.txt

    If MySQL was installed using the Wizard, add the defaults file command:

           --defaults-file="C:\\ProgramData\\MySQL\\MySQL Server 5.6\\my.ini"
  7. After MySQL server started, delete the __mysql-init` file.

DbSchema Database Designer


Alternatively, you can use a more general method that works on every system, but it’s less safe.

  1. Stop MySQL

  2. Restart it with the __–skip-grant-tables` option

     sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &
  3. Connect to MySQL server using the mysql client

     mysql -u root
  4. Reload all grant tables by executing:

  5. Set the new password for your account:

     SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');
  6. Stop the server and restart it normally. Now you should be able to connect using the __root` username and your new password.

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams, by double-clicking them. Changes will be saved to the design model and, if DbSchema is connected to the database also into the database. More.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected. Choose 'Edit Manually' into the JDBC URL combo to enter a custom URL. More.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys. Double-click cells to edit the data. More.

Query Builder alt >

Query Builder

Create SQL Queries featuring JOINS, GROUP BY, ORDER BY just using the mouse. More.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries. The editor is autocompletion-enabled. More.

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model. More.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme. More.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.