Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Use cmake to compile and install MySQL 5.5     - Static member variable modified (Programming)

- MySQL Error Code Complete (Database)

- Redis application of Sina Weibo (Database)

- Install JDK 1.7 + Eclipse in CentOS 6.4 in (Linux)

- Comparison of sorting algorithms (Programming)

- ASM required disk format process in Solaris platforms (Linux)

- Use Pylint regulate your Python code (Programming)

- Linux system performance and usage activity monitoring tools -Sysstat (Linux)

- A new method for Linux hidden files (Linux)

- Linux System Getting Started Learning: install software packages on Ubuntu and Fedora (Linux)

- To get Java class / jar package path (Programming)

- pga_aggregate_target and _pga_max_size can not use absolute limit actual PGA (Database)

- YUM install desktop environment in CentOS (Linux)

- When Linux Detailed time zone and common function of time (Linux)

- Hive handle count distinct inclination to produce data processing (Database)

- Android Delete project useless resource file (Programming)

- Docker build their own private warehouses (Linux)

- How to use the Vault secure password storage and API key (Linux)

- About Linux iptables firewall interview questions and answers (Linux)

- Gnu Linux - Ubuntu System Clean-term consolidation (Linux)

 
         
  Use cmake to compile and install MySQL 5.5
     
  Add Date : 2016-11-17      
         
         
         
  First cmake-2.8.8.tar.gz, mysql-5.5.32.tar.gz source package uploaded to the server.

Unpack and install cmake

[Root @ localhost ~] # tar -zxvf cmake-2.8.8.tar.gz
[Root @ localhost ~] # cd cmake-2.8.8
[Root @ localhost cmake-2.8.8] # ./configure
......
- Configuring done
- Generating done
- Build files have been written to: /root/cmake-2.8.8
---------------------------------------------
CMake has bootstrapped. Now run gmake.

Cmake make sure that no errors occurred

[Root @ localhost cmake-2.8.8] # echo $?
0

Run the following command gmake
[Root @ localhost cmake-2.8.8] # gmake
[Root @ localhost cmake-2.8.8] # gmake install

3. Install MySQL dependent table ncurses-devel

[Root @ localhost cmake-2.8.8] # yum install ncurses-devel -y

4. Create mysql user

[Root @ localhost cmake-2.8.8] # groupadd mysql
        
[Root @ localhost cmake-2.8.8] # useradd mysql -s / sbin / nologin -M -g mysql

5. Unzip compile MySQL

[Root @ localhost ~] # cd ..
[Root @ localhost ~] # tar -zxvf mysql-5.5.32.tar.gz
[Root @ localhost ~] # cd mysql-5.5.32
[Root @ localhost mysql-5.5.32] # cmake -DCMAKE_INSTALL_PREFIX = / application / mysql-5.5.32 \
  -DMYSQL_DATADIR = / Application / mysql-5.5.32 / data \
  -DMYSQL_UNIX_ADDR = / Application / mysql-5.5.32 / tmp / mysql.sock \
  -DDEFAULT_CHARSET = Utf8 \
  -DDEFAULT_COLLATION = Utf8_general_ci \
  -DWITH_EXTRA_CHARSETS = All \
  -DWITH_INNOBASE_STORAGE_ENGINE = 1 \
  -DWITH_ARCHIVE_STORAGE_ENGINE = 1 \
  -DWITH_BLACKHOLE_STORAGE_ENGINE = 1 \
  -DWITH_PERFSCHEMA_STORAGE_ENGINE = 1 \
  -DWITH_SSL = Yes \
  -DENABLED_LOCAL_INFILE = 1

[Root @ localhost mysql-5.5.32] # make && make install

Make a link to the installation directory

[Root @ localhost mysql-5.5.32] # ln -s /application/mysql-5.5.32/ / application / mysql

The source directory configuration file copy to the / etc directory

[Root @ localhost mysql-5.5.32] # cp support-files / my-small.cnf /etc/my.cnf

6. configuration environment variable

1 [root @ localhost mysql-5.5.32] # echo 'export PATH = / application / mysql / bin: $ PATH' >> / etc / profile

7. Authorizes the mysql user access to the installation directory

[Root @ localhost mysql] # chown mysql.mysql -R / application / mysql

8. Initialize mysql database

[Root @ localhost scripts] # ​​./mysql_install_db --basedir = / application / mysql --datadir = / application / mysql / data --user = mysql
Installing MySQL system tables ...
OK
Filling help tables ...
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:
 
/ Application / mysql / bin / mysqladmin -u root password 'new-password'
/ Application / mysql / bin / mysqladmin -u root -h localhost.localdomain password 'new-password'
 
Alternatively you can run:
/ Application / 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 / application / mysql; / application / mysql / bin / mysqld_safe &
 
You can test the MySQL daemon with mysql-test-run.pl
cd / application / mysql / mysql-test; perl mysql-test-run.pl
 
Please report any problems with the / application / mysql / scripts / mysqlbug script!

9. make mysql startup script

[Root @ localhost mysql-5.5.32] # cp support-files / mysql.server /etc/init.d/mysqld

10 start mysql

[Root @ localhost mysql-5.5.32] # /etc/init.d/mysqld start
Starting MySQL ..
     
         
         
         
  More:      
 
- PostgreSQL use pgpool achieve high availability (Database)
- PostgreSQL vacuum principle of a function and parameters (Database)
- Ubuntu: HDF5 error: HDF5 header version does not match with the HDF5 library (Linux)
- Security Knowledge: redirection command application security (Linux)
- Install the Red Hat Container Development Kit on OSX (Server)
- CentOS 7 version how to achieve the power to start the graphical interface (Linux)
- Linux kernel to achieve soft RPS network to receive soft interrupt load balancing to distribute (Linux)
- Oracle rebuild index script (Database)
- MySQL5.6 based GTID master-slave replication (Database)
- Ora-00439: feature not enabled: managed standby (Database)
- SQL statement to repair SQL Server database (Database)
- To install JDK1.7 and compiler Hadoop-2.7.1 under CentOS7 (Server)
- Mutt - an email client that sends messages through the terminal (Linux)
- ACL permissions Linux command (Linux)
- Configuring Sublime Text Python runtime environment 2 (Linux)
- About Nginx 7 (Server)
- Linux System Getting Started Learning: modify environment variables in Linux PATH (Linux)
- To install minimize RHEL / CentOS 7 (Linux)
- Why did not Oracle privileges can also log in with sysdba (Database)
- Linux shell script under the use of randomly generated passwords (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.