How do I log in to MySQL? cmd How to connect mysql database | | Log in to MySQL from a MySQL client

• 1
• 2
• 3
• 4
• 5
• 6
• 7

Step through Reading

MySQL Open source database, anyone can download the installation using. So how does the installed MySQL log in to connect to the MySQL database? This experience introduces several common methods of Nithya

Tools/Materials

• Mysql

Several ways to connect MySQL database

2. 1

   A MySQL command line connection

   Generally for the newly installed MySQL, if you check the Enable MySQL lineclient. You can---mysql command line client directly by finding the start---program

4. 2

   After clicking on the MySQL command line, you will be prompted to enter the root password. After entering the correct root password, you can connect to the MSYQL database.

6. 3

   Two cmd command line how to connect a database

   If the MySQL command line is not installed, we can find the path where the mysqld is located (copy the path of Mysqld.exe)

8. 4

   Use the CD to switch to the Msyqld.exe path, and then enter the MySQL connection command as

   The format is:

   Mysql-p Port number-H MySQL host name \ip-u root (user)-P

10. 5

    If the command line is the local computer where MySQL is located

    And with the default port 3306 direct input mysql-u root-p can be

12. 6

    Third-party MySQL database connection tool

    Through third-party database connection Tools These are many, such as setting the relevant parameters can be

14. 7

    After the connection, it is a more user-friendly graphical interface.

    More about MySQL Database Tools navicat for MySQL how to use?

    Http://jingyan.baidu.com/article/3c343ff70d0ee00d37796397.html

16. 8

    Other Remote connection Tools

    Phpmyadmin is undoubtedly the most widely used graphical tool for the PHP management database, due to the different environments and paths involved. In this case, Nithya does not do the detailed operation

    END

Other precautions

1. 1

   The default MySQL is only native login, if the need for the external network to connect properly.

   Need to set open permissions to the Mysql\user form, such as hosts is a host that can be connected remotely

   END

Precautions

• In addition to the same as the PHP MySQL connection parameters, MySQL ODBC connection control to connect MySQL, and so on, these nithya not more than a professional to rip eggs.
• This experience for Nithya original operation, Baidu experience first. Without permission, refuse to reprint! If you have any questions, please leave a message, thank you for your support!

How do I log in to MySQL? cmd How to connect mysql database | | Log in to MySQL from a MySQL client