国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 數據庫 > MySQL > 正文

Mysql 5.6.24安裝實例教程

2024-07-24 13:11:29
字體:
來源:轉載
供稿:網友

安裝前準備工作:

1)編輯PATH路徑

vim /etc/profilePATH=/home/mysql/bin:/home/mysql/lib:$PATHexport PATH

2)生效PATH

source /etc/profile

3)編輯hosts

vim /etc/hosts192.168.117.130 cc-test

安裝

1.環境配置

yum install - y gcc gcc-c++ make cmake

2.準備好安裝包mysql-5.6.24.tar.gz,并將它拷貝到/home目錄下

rz

3.解壓安裝包并更名

tar -zxvf mysql-5.6.2.tar.gzmv mysql-5.6.2.tar.gz mysql

 

4.新增用戶組 及用戶

groupadd mysqluseradd mysql -g mysql

5.創建data

mkdir /home/mysql/data

6.編譯mysql

cmake /-DCMAKE_INSTALL_PREFIX=/home/mysql /-DMYSQL_UNIX_ADDR=/home/mysql/mysql.sock /-DDEFAULT_CHARSET=utf8 /-DDEFAULT_COLLATION=utf8_general_ci /-DWITH_MYISAM_STORAGE_ENGINE=1 /-DWITH_INNOBASE_STORAGE_ENGINE=1 /-DWITH_ARCHIVE_STORAGE_ENGINE=1 /-DWITH_BLACKHOLE_STORAGE_ENGINE=1 /-DWITH_MEMORY_STORAGE_ENGINE=1 /-DWITH_READLINE=1 /-DENABLED_LOCAL_INFILE=1 /-DMYSQL_DATADIR=/home/mysql/data /-DMYSQL_USER=mysql /-DMYSQL_TCP_PORT=3306

7.安裝

make installmake clean

8.修改目錄擁有者

chown -R mysql:mysql /home/mysqlchown -R mysql:mysql /home/mysql/data

9.初始化配置腳本

scripts /mysql-install-db --user=nysql --datadir=/home/mysql/data

10.重新更改權限

chown -R mysql:mysql /home/mysql

11.復制服務器啟動腳本

cp /home/mysql/support-files/mysql.server /etc/init.d/mysqlchmod 755 /etc/init.d/mysqlcp /home/mysql/support-files/my-default.cnf /etc/my.cnf

12.啟動

service mysqld start

13.netstat -anp 查看端口是否監聽上

14.進入mysql

cd /mysql/bin./mysql -u root -p

問題1:

[root@cc-test mysql]# cmake .

出現以下錯誤提示:

-- Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)CMake Error at cmake/readline.cmake:82 (MESSAGE):Curses library not found. Please install appropriate package,remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.Call Stack (most recent call first):cmake/readline.cmake:126 (FIND_CURSES)cmake/readline.cmake:216 (MYSQL_USE_BUNDLED_LIBEDIT)CMakeLists.txt:250 (MYSQL_CHECK_READLINE)-- Configuring incomplete, errors occurred!

解決方法:

[root@cc-test mysql]# rm CMakeCache.txt[root@cc-test mysql]# yum install ncurses-develWarning: Bison executable not found in PATH-- Configuring done-- Generating done-- Build files have been written to: /software/mysql-5.5.11[root@cc-test mysql]# yum install bison[root@cc-test mysql]# cmake ……[root@cc-test mysql]# make install

問題2:

[root@cc-test mysql]# scripts/mysql_install_db --user=mysql --datadir=/home/mysql/data-bash: scripts/mysql_install_db: Permission denied

解決方法:

[root@cc-test mysql]# chmod 755 scripts/mysql_install_db

問題3:

service mysqld start 啟動時發生 PID錯誤

解決方法:

chown -R mysql.mysqlsu - mysql-bash-4.1$ (ctrl+d)scripts /mysql.install_db/home/mysql/bin/mysql_safe --user=mysql&/etc/rc.d/init.d/mysqld status/etc/rc.d/init.d/mysqld start

以上所述是小編給大家介紹的Mysql 5.6.24安裝實例教程,希望對大家有所幫助,如果大家有任何疑問請給我留言,小編會及時回復大家的。在此也非常感謝大家對VeVb武林網網站的支持!


注:相關教程知識閱讀請移步到MYSQL教程頻道。
發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 密山市| 恩平市| 井研县| 铜梁县| 奉新县| 鹿泉市| 安龙县| 北票市| 济阳县| 浦江县| 乌兰浩特市| 松滋市| 梅河口市| 鱼台县| 鲁山县| 抚远县| 桃源县| 渭源县| 呼玛县| 宕昌县| 怀来县| 新余市| 嫩江县| 淮北市| 航空| 朝阳市| 汾阳市| 林口县| 绥芬河市| 四子王旗| 滕州市| 临城县| 曲靖市| 阜宁县| 平遥县| 莱西市| 龙游县| 虎林市| 汉沽区| 衡水市| 长海县|