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 --------------------------------------