HP-UX install MySQL

1. Environment Introduction Operating System: HP-UXB.11.31ia64 installation medium: mysql-5.1.48-hpux11.31-ia64-64bit.depot.gz2, Installation Process (1) Create mysql

1. Environment Introduction Operating System: HP-UX B .11.31 ia64 installation media: mysql-5.1.48-hpux11.31-ia64-64bit.depot.gz 2. Installation Process (1) Create mysql

1. Environment Introduction

HP-UX B .11.31 ia64 Operating System

Installation medium: mysql-5.1.48-hpux11.31-ia64-64bit.depot.gz

2. Installation Process

(1) Create mysql users and user groups

# Groupadd mysql

# Useradd-g mysql-d/home/mysql-s/usr/bin/ksh mysql

# Passwd mysql

(2) decompress the installation package

$ Gunzip mysql-5.1.48-hpux11.31-ia64-64bit.depot.gz

(3) install swinstall

# Swinstall-s/tmp/mysql-5.1.48-hpux11.31-ia64-64bit.depot

Note: Generally, the full path must be written.

(4) character interface Installation

Space key selected and installed on the menu bar

(5) set owner and Create Symbolic Links

# Cd/usr/local

# Chown-R mysql: mysql mysql-5.1.48-hpux11.31-ia64-64bit

# Ln-s mysql-5.1.48-hpux11.31-ia64-64bit mysql

Note: The default installation to the/usr/local/mysql-5.1.48-hpux11.31-ia64-64bit directory ,,

Here, create a symbolic link:/usr/local/mysql

(6) Create a system database

# Su-mysql

$ Cd/usr/local/mysql

$ Scripts/mysql_install_db -- user = mysql

(7) Start the database

$ Cd/usr/local/mysql/bin

$./Mysqld_safe -- user = mysql &

(8) remote access to other MySQL Databases

$ Mysql-u -P-h 192.168.1.102-P 3306-D

(9) Character Set settings

When accessing other MySQL databases as a client, character sets may be inconsistent, leading to garbled characters.

The solution is to configure the/etc/my. cnf file to ensure that the character set and far end are consistent. If no/etc/my. cnf, which can copy my-medium.cnf files from the/usr/local/mysql/support-files directory to/etc/my. cnf: add a line in the [client] section:

Default-character-set = gbk

Restart mysql to take effect. Verify the access to the remote database again, and the query of Chinese characters is normal.

-------------------------------------- Split line --------------------------------------

Install MySQL in Ubuntu 14.04

MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF

Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL

Build a MySQL Master/Slave server in Ubuntu 14.04

Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS

Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04

MySQL-5.5.38 universal binary Installation

-------------------------------------- Split line --------------------------------------