Shulou(Shulou.com)06/02 Report--

How does linux log in to mysql? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Linux is a free-to-use and free-spread Unix-like operating system. It is a multi-user, multi-task, multi-threaded and multi-CPU operating system based on POSIX and UNIX. It runs major UNIX tools, applications, and network protocols. It supports 32 bit and 64 bit hardware. Linux inherits the design idea of Unix with network as the core, and is a multi-user network operating system with stable performance.

MySQL is a relational database management system developed by the Swedish company MySQL AB and currently belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software.

How does linux log in to mysql?

The way mysql logs in is as follows:

[root@crmtestdb root] # mysql-u root-h 127.0.0.1Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 3Server version: 5.0.45-community MySQL Community Edition (GPL) Type''help;'' or''\ hobby 'for help. Type'\ censor'to clear the buffer.mysql >

If you have a password, log in as follows:

Mysql-u root-h 127.0.0.1-p

As to which database to use and which to use, it should look like this:

Mysql > show databases;+-+ | Database | +-+ | information_schema | | mysql | | test | | wt | +-+ 4 rows in set (0.00 sec) mysql > use testDatabase changedmysql > Thank you for reading! After reading the above, do you have a general idea of how linux logs into mysql? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

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.