建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
LinuxCentos7安裝MySQL5.5(二進制方式安裝)
Linux Centos7安裝MySQL5.5(二進制方式安裝)
一、在/app目錄下下載mysql-5.5.54-linux2.6-x86_64.tar.gz`
[root@test /]# cd /app
[root@test app]# wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.54-linux2.6-x86_64.tar.gz二、解壓mysql-5.5.54-linux2.6-x86_64.tar.gz
[root@test app]# ta zvxf mysql-5.5.54-linux2.6-x86_64.tar.gz
創(chuàng)新互聯(lián)建站是一家以網(wǎng)絡(luò)技術(shù)公司，為中小企業(yè)提供網(wǎng)站維護、成都網(wǎng)站制作、成都網(wǎng)站建設(shè)、網(wǎng)站備案、服務(wù)器租用、域名注冊、軟件開發(fā)、重慶小程序開發(fā)等企業(yè)互聯(lián)網(wǎng)相關(guān)業(yè)務(wù)，是一家有著豐富的互聯(lián)網(wǎng)運營推廣經(jīng)驗的科技公司，有著多年的網(wǎng)站建站經(jīng)驗，致力于幫助中小企業(yè)在互聯(lián)網(wǎng)讓打出自已的品牌和口碑，讓企業(yè)在互聯(lián)網(wǎng)上打開一個面向全國乃至全球的業(yè)務(wù)窗口：建站咨詢電話：18980820575
三、將解壓后的mysql-5.5.54-linux2.6-x86_64改名為mysql
[root@test app]# mv mysql-5.5.54-linux2.6-x86_64 mysql
四、添加/etc/my.cnf文件
[root@test app]# cd /app/mysql/support-files/
[root@test support-files]# cp -f my-small.cnf /etc/my.cnf五、創(chuàng)建mysql目錄下的data目錄
[root@test support-files]# mkdir -p /app/mysql/data/六、將mysql的所屬用戶改為mysql
[root@test support-files]# chown -R mysql.mysql /app/mysql/七、增加/etc/init.d/mysqld，并為之賦予執(zhí)行權(quán)限，然后初始化MySQL
[root@test support-files]# cp -f mysql.server /etc/init.d/mysqld
[root@test support-files]# chmod +x /etc/init.d/mysqld
【初始化MySQL】
[root@test support-files]# /app/mysql/scripts/mysql_install_db --basedir=/app/mysql --datadir=/app/mysql/data --user=mysql八、將 /application/mysql/bin/mysqld_safe和/etc/init.d/mysqld中的/usr/local/mysql改為/app/mysq
[root@test support-files]# sed -i 's#/usr/local/mysql#/app/mysql#g' /app/mysql/bin/mysqld_safe /etc/init.d/mysqld九、啟動mysql
[root@test support-files]# /etc/init.d/mysqld start
Starting MySQL.Logging to '/app/mysql/data/test.err'.
.. SUCCESS! 十、檢查mysql是否啟動
[root@test support-files]# netstat -lntup | grep mysql
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 5478/mysqld 十一、設(shè)置環(huán)境變量
[root@test support-files]# echo 'export PATH=/app/mysql/bin:$PATH' >>/etc/profile
[root@test support-files]# source /etc/profile
十二、進入mysql
[root@test support-files]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.54 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> 十三、修改root密碼
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
十四、退出MySQL，使用用戶名和密碼再次登錄MySQL
mysql> Ctrl-C -- exit!
Aborted
[root@test support-files]# mysql -uroot -p
Enter password: 十五、創(chuàng)建數(shù)據(jù)庫和表（指定utf-8編碼格式）
mysql> create database userInfo DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.00 sec)
mysql> use userInfo;
Database changed
mysql> create table test (
-> name varchar(10) not null,
-> address varchar(100) default null)
-> ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Query OK, 0 rows affected (0.06 sec)十六、導(dǎo)入sql文件（若需要執(zhí)行此步驟）
mysql> source /app/cloud_note.sql
mysql> show databases;
網(wǎng)站標(biāo)題：LinuxCentos7安裝MySQL5.5(二進制方式安裝)
路徑分享：http://biofuelwatch.net/article/pegejs.html
