Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Use cmake to compile and install MySQL 5.5     - ORA-38856: Unable instance UNNAMED_INSTANCE_2 (redo thread 2) marked enabled (Database)

- Linux screen commonly commands (Linux)

- How to install the latest version of the Eclipse in Ubuntu 14.04 (Linux)

- RPM package fabrication method (Linux)

- How ONLYOFFICE collaborative editing document on Linux (Linux)

- to install the deployment of LVS under CentOS 7.0 (Server)

- Use smartmontools view the health status of hard disk (Linux)

- Unable to solve the official version of Android Studio online update problem (Linux)

- To access an Oracle database using Instant Client (Database)

- After installing minimize RHEL / CentOS 7 need to do some things (Linux)

- Oracle SDE and maintain common commands - Display space (Database)

- System-level alias vs Oracle ADR functionality (Database)

- C language keywords Comments (Programming)

- PostgreSQL export table structure information (Database)

- Linux kernel netpoll framework netconsole (Linux)

- C ++ pointer two third memory model (Programming)

- Sorting algorithm of dichotomy (binary) insertion sort algorithm (Programming)

- GNU / Linux enable Intel Rapid Start (Linux)

- Red Hat Linux security settings document (Linux)

- Smooth upgrade to OpenSSH 6.7 Procedure (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:      
 
- Use mdadm tool to create software RAID 0 (Linux)
- Linux Network Analysis Tcpdump Command Guide (Linux)
- Use PDFBox parse PDF file (Linux)
- When Linux Detailed time zone and common function of time (Linux)
- Python Basics: Search Path (Programming)
- Management Linux Container with Docker in Ubuntu (Linux)
- MySQL log from the library than the main library (Database)
- Linux host dual LAN transceiver package ARP problem (Linux)
- Ubuntu way of decompressing files (Linux)
- JavaScript prototype and prototype chain and project combat (Programming)
- WordPress plug-ins installed in Ubuntu, enter the subject of FTP and not create directory problem (Server)
- Proxmox VE implement KVM OpenVZ virtualization cloud computing (Server)
- Lua and C ++ (Programming)
- Linux OOM killer mechanism (Linux)
- Sublime Text 3 (Linux)
- Ubuntu Server (Ubuntu 14.04 LTS 64-bit) installation libgdiplus 2.10.9 error solution (Linux)
- MogileFS system installation configuration example (Server)
- Configuring a Linux operating system against syn attack (Linux)
- CentOS / RHEL 6 was repeated prohibited under the SNMP connection log (Server)
- VMware virtual machine to use bridged mode fast Internet access (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.