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

Operating system: CentOSrelease 6.8 (Final)

Virtual machine: VMware

Database: mysql-5.5.53.tar.gz

Note: the installation mode of the version after the source code installation package mysql-5.5.32.tar.gz has changed.

The installation steps are as follows:

# rpm-qa | grep mysql

# yum remove mysql*

# yum install cmake ncurses.x86_64 ncurses-devel.x86_64 bison-devel

# groupadd mysql

# useradd-g mysql mysql-s nologin

# mkdir-p application

# cd / application

Application# mkdir mysql/data-p

# chmod-R 777 / mysql/data

# chmod-R 777 / mysql/data-p

# chmod-R 777 / mysql/data-f

# chown-R mysql:mysql / mysql

# chown-R mysql:mysql / mysql/data

# mkdir / var/lib/mysql

# chown-R mysql:mysql / var/lib/mysql

# rz # upload from terminal to server

# tar xf mysql-5.5.53.tar.gz

[root@localhost mysql-5.5.53] #

Cmake\

-DCMAKE_INSTALL_PREFIX=/application/mysql\

-DMYSQL_DATADIR=/application/mysql/data\

-DSYSCONFDIR=/etc\

-DWITH_MYISAM_STORAGE_ENGINE=1\

-DWITH_INNOBASE_STORAGE_ENGINE=1\

-DWITH_MEMORY_STORAGE_ENGINE=1\

-DWITH_READLINE=1\

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock\

-DMYSQL_TCP_PORT=3306\

-DENABLED_LOCAL_INFILE=1\

-DWITH_PARTITION_STORAGE_ENGINE=1\

-DEXTRA_CHARSETS=all\

-DDEFAULT_CHARSET=utf8\

-DDEFAULT_COLLATION=utf8_general_ci

[root@localhost mysql-5.5.53] # make & & make install

[root@localhost support-files] # cp my-small.cnf / etc/my.cnf

[root@sky9890 scripts] # / mysql_install_db-- basedir=/usr/local/mysql-- datadir=/usr/local/mysql/data-- user=mysql

WARNING: The host'* 'could not be looked up with resolveip.

This probably means that your libc libraries are not 100% compatible

With this binary MySQL version. The MySQL daemon, mysqld, should work

Normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames

When specifying MySQL privileges!

Installing MySQL system tables...

181025 7:57:40 [Note] Ignoring-- secure-file-priv value as server is running with-- bootstrap.

181025 7:57:40 [Note] / usr/local/mysql/bin/mysqld (mysqld 5.5.62) starting as process 18880.

OK

Filling help tables...

181025 7:57:41 [Note] Ignoring-- secure-file-priv value as server is running with-- bootstrap.

181025 7:57:41 [Note] / usr/local/mysql/bin/mysqld (mysqld 5.5.62) starting as process 18887.

OK

To start mysqld at boot time you have to copy

Support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER!

To do so, start the server, then issue the following commands:

/ usr/local/mysql/bin/mysqladmin-u root password' new-password'

/ usr/local/mysql/bin/mysqladmin-u root-h * password' new-password'

Alternatively you can run:

/ usr/local/mysql/bin/mysql_secure_installation

Which will also give you the option of removing the test

Databases and anonymous user created by default. This is

Strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

Cd / usr/local/mysql; / usr/local/mysql/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

Cd / usr/local/mysql/mysql-test; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

Configure the environment variables for mysql:

# vim / etc/profile.d/mysql.sh

# export PATH=/usr/local/mysql/bin:$PATH

# source / etc/profile.d/mysql.sh takes effect immediately

Start MySQL

Add services, copy service scripts to the init.d directory, and set boot up

# cp support-files/mysql.server / etc/init.d/mysqld

# chkconfig mysqld on

# chkconfig mysqld-- level 2345 on

# service mysqld start

Configure root user

After MySQL starts successfully, root has no password by default. We need to set the root password.

# mysql

Mysql > SET PASSWORD = PASSWORD ('*')

Actual combat technology:

[root@sky9890 ~] # mysql

-bash: mysql: command not found

[root@sky9890] # ln-s / usr/local/mysql/bin/mysql / usr/bin

[root@sky9890 ~] # mysql

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[root@sky9890] # mysql-V

Mysql Ver 14.14 Distrib 5.5.62, for Linux (x86 / 64) using EditLine wrapper

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.