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

This article will explain in detail how to install Mysql under Ubuntu. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

I always found it troublesome to install MySQL under Linux, because the previous installation was a little dizzy due to complex configuration. Today, you need to connect to MySQL with Qt under Linux. Then install and configure one.

1) first check whether MySQL has been installed in the system

Enter sudo netstat-tap in the terminal | grep mysql

If there is no reflection and the installed result is not displayed, there is no installation. If shown below, it is already installed

2) if it is not installed, install MySQL.

Enter sudo apt-get install mysql-server mysql-client at the terminal

The running result is as follows:

During this installation, you will be asked to enter the password of the root user (administrative MySQL database user, non-Linux system user) and enter it as required. As follows:

3) Test whether the installation is successful:

Enter sudo netstat-tap at the terminal | grep mysql

If the following results occur, the installation is successful:

4) you can also pass the login MySQL test

Enter mysql-uroot-p at the terminal and then prompt you to enter the password, enter the correct password, and then enter. As follows:

5) some simple management of MySQL:

Start the MySQL service: / etc/init.d/mysql start

Stop the MySQL service: / etc/init.d/mysql stop

Modify the administrator password of MySQL: sudo mysqladmin-u root password newpassword

Set up remote access (normally, port 3306 occupied by mysql only listens on IP 127.0.0.1, denying access to other IP (which can be seen through netstat). Abolish local supervision

You need to modify the my.cnf file:):

Sudo vi / etc/mysql/mysql.conf.d/mysqld.cnf

Bind-address = 127.0.0.1 / / find this content and comment

Netstat-an | grep 3306 to view port information

6) Analysis of the directory structure after MySQL installation (this structure is only for online installation using apt-get install):

Database storage directory: / var/lib/mysql/

Directory for storing related configuration files: / usr/share/mysql

Related command storage directory: / usr/bin (mysqladmin mysqldump, etc.)

Startup footsteps storage directory: / etc/rc.d/init.d/

7) MySQL graphical management software

Generally speaking, there are two better ones, one is open source and the other is commercial charge:

Open source: MySQL Workbench (introduction to specific usage, I will summarize it slowly as I use it)

Business: Navicat (for a fee, there is a 30-day experience, and then I'm sure you'll find a way)

At this point, the installation and configuration of MyQL under Linux (Ubuntu) are all completed.

On "how to install Mysql under Ubuntu" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.

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.