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

Source: Internet
Author: User
Tags mysql client mysql host odbc connection php mysql mysql command line

    • 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
  1. 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

  2. 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.

  3. 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)

  4. 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

  5. 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

  6. 6

    Third-party MySQL database connection tool

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

  7. 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

  8. 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.