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

The following content mainly brings you how Centos installs the MySQL database. The knowledge mentioned here, which is slightly different from books, is summed up by professional and technical personnel in the process of contact with users, and has a certain value of experience sharing. I hope to bring help to the majority of readers.

I. Foundation of MySQL services

MySQL is a real multi-threaded, multi-user SQL database service. With its high performance, high reliability and easy to use, it has become the most popular open source database system in the field of cloud servers.

The MySQL project was developed, released and supported by MySQL AB before 2008. After that, Sun acquired MySQL AB and Oracle acquired Sun. At present, Oracle is responsible for the operation and maintenance of the MySQL project.

II. Compilation and installation of MySQL

In order to ensure the integrity and customization of the MySQL database function, I installed the MySQL database system by compiling and installing the source code. The MySQL5.X series version is the most widely used, and its stability and compatibility are good. The official site for downloading the source code package is https://www.mysql.com.

1. Preparatory work

Download and install the required software package: https://pan.baidu.com/s/1vMP72gT6oELBb5eKNTbhNw

Extraction code: gxtf

[root@centos01 ~] # mount / dev/cdrom / mnt/ [root@centos01 ~] # groupadd mysql [root@centos01 ~] # useradd-M-s / sbin/nologin mysql-g mysql [root@centos01 ~] # rm-rf / etc/yum.repos.d/CentOS-* [root@centos01 ~] # yum-y install ncurses-devel 2, Install cmake package [root@centos01 ~] # umount / mnt/ [root@centos01 ~] # mount / dev/cdrom / mnt/ [root@centos01 ~] # mount / dev/cdrom / mnt/ [root@centos01 ~] # cd / usr/src/cmake-2.8.6/ [root@centos01 cmake-2.8.6] #. / configure [root@centos01 cmake-2.8.6] # gmake & & gmake install 3, source code compilation and installation

[root@centos01 ~] # tar zxvf / mnt/mysql-5.5.22.tar.gz-C / usr/src/ [root@centos01 ~] # cd / usr/src/mysql-5.5.22/ [root@centos01 mysql-5.5.22] # cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS=all-DSYSCONFDIR=/etc [root@centos01 mysql-5.5.22] # make & & make install

In the above configuration command, the meaning of each option is as follows:

-DCMAKE_INSTALL_PREFIX: specifies that the MyQSL database program is installed in a directory, such as directory / usr/local/mysql. -DSYSCONFDIR: specifies the initialization parameter file directory. -DDEFAULT_CHARSET: specifies the character set encoding used by default, such as utf-8. -DDEFAULT_COLLATION: specifies the default character set proofreading rules. Utf8_general_ci is a general rule applicable to the utf-8 character set. -DWITH_EXTRA_CHARSETS: specifies additional character set encodings that are supported. 4. Other adjustments after installation [root@centos01 ~] # chown-R mysql:mysql / usr/local/mysql/ [root@centos01 ~] # cd / usr/src/mysql-5.5.22/ [root@centos01 mysql-5.5.22] # cp support-files/my-medium.cnf / etc/my.cnf cp: is "/ etc/my.cnf" overwritten? Y [root@centos01 ~] # vim / etc/profile # / etc/profile PATH= "$PATH:/usr/local/mysql/bin/" [root@centos01 ~] # source / etc/profile [root@centos01 mysql-5.5.22] # cp support-files/mysql.server / etc/init.d/mysqld [root@centos01 mysql-5.5.22] # chmod + x / etc/init.d/mysqld [root@centos01 ~] # chkconfig-- add Mysqld [root@centos01] # chkconfig-level 35 mysqld on [root@centos01] # / usr/local/mysql/scripts/mysql_install_db-user=mysql-basedir=/usr/local/mysql-datadir=/usr/local/mysql/data 5, Start the MySQL service [root@centos01 ~] # systemctl enable mysqld [root@centos01 ~] # systemctl start mysqld [root@centos01 ~] # netstat-anptu | grep 3306 III. Access MySQL database

MySQL database system is a typical application of client / server architecture. Special client software is required to access the MySQL database. In Linux system, the simplest and most easy-to-use MySQL client software is its own mysql command tool.

1. Log in to the MySQL server

After the initialization process after installation, the default administrator user name for the MySQL database is root and the password is empty.

After the login is successful, you will enter the database operating environment with the prompt "mysql >", and users can enter various operation statements to manage the database. Each MySQL operation statement ends with a semicolon ";" and can be entered without case sensitivity.

[root@centos01 ~] # mysql-u root-p New password: mysql > exit [root@centos01 ~] # mysqladmin-u root password New password: Confirm new password: [root@centos01 ~] # mysql-u root-p Enter password: mysql > quit IV, use MySQL database mysql > show databases; mysql > use myqsl; mysql > show tables; mysql > describe user; mysql > create database bdqn Mysql > drop database bdqn; mysql > create table stuinfo (name char (16), gender char (10), age char (10), contact telephone number char (11), Email address char (20); mysql > drop table stuinfo; mysql > insert into stuinfo (name, sex, age, contact telephone number, Email address) value ('Li Yuexin', 'male','20 years', '18232013151') !-- stuinfo table inserts data-- > mysql > insert into stuinfo value ('Wu Dalang', 'male', '1919' Magi 1111111111'); mysql > insert into stuinfo value ('Zhang Hang', 'male', '15Zhu 222222'); mysql > insert into stuinfo value ('Zeng Xianmou', 'male', '8Han'); mysql > select * from stuinfo') +-+ | name | Sex | Age | contact number | Email address | +-+-+ -+ | Li Xianxin | male | 20 | 18232013151 | 2807489749@qq.com | | Wu Dalang | male | 19 | 11111111111 | 11111111@qq.com | | Zhang Hang | male | 15 | 222222222222 | 22222222@qq.com | | Zeng Xianmou | male | | | 8 | 33333333333 | 33333333@qq.com | +-+ mysql > select * from stuinfo where name ='Li Hanxin'| +-+ | name | Sex | Age | contact number | Email address | +-- -+ | Li Xiexin | male | 20 | 18232013151 | 2807489749@qq.com | +- -+ mysql > update stuinfo set name = 'LiYanXin' where name =' Li Gexin' Mysql > delete from stuinfo where name = 'LiYanXin'; 5. Database user authorization

The root user account of MySQL database has full permissions to all databases and tables. Frequent use of root account will bring certain security risks to the database server. Usually in the actual work, some low-privilege users will be established, who are only responsible for the management and maintenance of part of the database and tables, and can even make further refinement restrictions on various operations such as query, modification, deletion of records, and so on. In order to minimize the risk of the database.

1. Grant permissions

GRANT statement: specifically used to set the access rights of database users. When the specified user name does not exist, the GRANT statement creates a new user; otherwise, the GRANT statement is used to modify the user information.

The statement format is as follows:

GRANT permission list ON library name. Table name TO username @ source address [IDENTIFIED BY 'password']

When using the Grant statement, you need to pay attention to the following:

List of permissions: used to list the various database operations authorized to use, separated by commas, Select allows query; Insert inserts data; Update updates data; Delete deletes data; All gives all permissions and adds deletions and corrections to check; use "all" to indicate all permissions and authorize any operation. Name of the library. Table name: the name of the library and table used to specify the authorized operation, where the wildcard character "" can be used. "auth." Indicates that the object of the authorized operation is all tables in the auth library. User name @ source address: used to specify the user name and the client address that is allowed to access, that is, who can connect and where to connect. The source address can be a domain name, an IP address, or you can use the "%" wildcard to represent all addresses in an area or network segment. IDENTIFIED BY: used to set the password string that the user uses to connect to the database. When you create a new user, if you omit the "IDENTIFIED BY" section, the user's password will be empty. Mysql > grant all on bdqn.* to 'rundb'@'localhost' identified by' pwd@123'; mysql > show grants for 'rundb'@'localhost'; mysql > revoke all on bdqn.stuinfo from' rundb'@'localhost'

For the above about how to install the MySQL database in Centos, if you need to know more, you can continue to pay attention to the innovation of our industry. If you need professional answers, you can contact the pre-sales and after-sales on the official website. I hope this article can bring you some knowledge updates.

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.