Shulou(Shulou.com)05/31 Report--

This article mainly explains the "MySQL database login methods", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "MySQL database login methods" bar!

What are the login methods for MySQL database? MySQL database login method: to complete the login operation, first enter the command line interface of the machine and enter the command as follows:

Mysql-h hostname-u username-p

The mysql command invokes the mySQL monitor. This is an open command line that connects us to the mySQL server client.

The-h command option specifies the host you want to connect to, that is, the machine running the mySQL server. If you are on the machine on which the mySQL server is running

By running this command, you can ignore this option and the hostname parameter. If not, the hostname parameter must be used as the hostname where the mySQL server is running.

The-u command option has the courage to specify the user name to use when connecting to the database. If not specified, the default value is the user name used when logging in to the operating system.

If you have mySQL installed on your machine or server, you must log in as root and create a database. Assume that the mySQL database is installed and that the root user is the user performing various operations. If someone else

If mySQL is used on the managed machine, you must use the user name provided by them.

The-p command option is used to tell the server to use a password to connect to it, and can be ignored if the user name used when logging in does not have a password set.

If logging in as a root user does not have a root password set, then you need to set a root password, and it is not secure without a root password system.

We do not need to include the password in our command, the mySQL server will ask for the password, and after entering the appeal order, we will get the following response:

Enter password:

(if no line command appears, verify that the mySQL server is running and that the above mySQL command should be included in the path. ) you must enter a password. If all goes well, you will get a response similar to the following:

Welcome to the mySQL monitor.Commands end with; or\ g.

Your mySQL connection id is 1 to server version:5.1.25-rc-community mySQL community Server (GPL)

Type' help;'or'\ h'for help.Type'\ c'to clear the buffer.

Mysql >

If you don't get a similar response on your own machine, verify that mysql_install_db is running (if necessary), that the root password is set, and that the password entered is correct.

Thank you for your reading, the above is the content of "what are the login methods for MySQL database". After the study of this article, I believe you have a deeper understanding of what login methods MySQL database has, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.