站長資訊網
        最全最豐富的資訊網站

        linux上怎么使用cmake安裝mysql?

        方法:1、安裝ncurses-devel依賴包;2、下載并解壓mysql壓縮包;3、使用cd命令進入mysql文件夾,使用cmake命令進行配置解析;4、使用“make && make install”命令安裝mysql即可。

        linux上怎么使用cmake安裝mysql?

        (推薦教程:mysql視頻教程)

        一、安裝cmake

        1、解壓cmake壓縮包

        [root@mysql tools]# tar -zvxf cmake-2.8.8.tar.gz [root@mysql tools]# ls cmake-2.8.8 cmake-2.8.8.tar.gz mysql-5.5.16.tar.gz scripts

        2、解析

        [root@mysql tools]# cd cmake-2.8.8 [root@mysql cmake-2.8.8]# ./configure --------------------------------------------- CMake 2.8.8, Copyright 2000-2009 Kitware, Inc. Found GNU toolchain C compiler on this system is: gcc C++ compiler on this system is: g++ Makefile processor on this system is: gmake g++ is GNU compiler g++ has STL in std:: namespace g++ has ANSI streams g++ has streams in std:: namespace

        3、安裝

        [root@mysql cmake-2.8.8]# echo $? 0 #如果返回值是0,就是執行成功,如果返回值是1,就是執行失敗;  [root@mysql cmake-2.8.8]# gmake && gmake install Scanning dependencies of target cmIML_test [ 1%] Building C object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test.c.o [ 1%] Building C object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_ABI_C.c.o [ 1%] Building C object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_INT_C.c.o [ 1%] Building C object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_include_C.c.o [ 2%] Building CXX object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_ABI_CXX.cxx.o [ 2%] Building CXX object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_INT_CXX.cxx.o [ 2%] Building CXX object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_include_CXX.cxx.o

        二、開始安裝mysql

        1、首先需要安裝(ncurses-devel)依賴包

        [root@mysql cmake-2.8.8]# cd … [root@mysql tools]# yum -y install ncurses-devel Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile  base: mirrors.zju.edu.cn extras: centos.ustc.edu.cn updates: mirrors.zju.edu.cn Resolving Dependencies –> Running transaction check —> tools ncurses-devel.x86_64 0:5.9-14.20130511.el7_4 will be installed #############安裝完成后檢查########### [root@mysql tools]# rpm -qa | grep ncurses-devel ncurses-devel-5.9-14.20130511.el7_4.x86_64 [root@mysql tools]#

        2、解壓mysql壓縮包

        [root@mysql tools]# tar -zvxf mysql-5.5.16.tar.gz [root@mysql tools]# ls cmake-2.8.8 cmake-2.8.8.tar.gz mysql-5.5.16 mysql-5.5.16.tar.gz scripts [root@mysql tools]#

        3、創建虛擬用戶

        [root@mysql tools]# useradd mysql -s /sbin/nologin -M [root@mysql tools]# id mysql uid=1000(mysql) gid=1000(mysql) groups=1000(mysql) [root@mysql tools]#

        4、配置解析

        [root@mysql tools]# cd mysql-5.5.16 [root@mysql mysql-5.5.16]# [root@mysql mysql-5.5.16]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.5.16 -DMYSQL_DATADIR=/usr/local/mysql-5.5.16/data -DMYSQL_UNIX_ADDR=/usr/local/mysql-5.5.16/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii -DENABLED_LOCAL_INFILE=ON -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 -DWITHOUT_PARTITION_STORAGE_ENGINE=1 -DWITH_FAST_MUTEXES=1 -DWITH_ZLIB=bundled -DENABLED_LOCAL_INFILE=1 -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 -DWITH_DEBUG=0

        5、安裝

        [root@mysql mysql-5.5.16]# make && make install Scanning dependencies of target INFO_BIN [ 0%] Built target INFO_BIN Scanning dependencies of target INFO_SRC [ 0%] Built target INFO_SRC Scanning dependencies of target abi_check [ 0%] Built target abi_check Scanning dependencies of target zlib

        6、創建軟連接

        [root@mysql mysql-5.5.16]# ln -s /usr/local/mysql-5.5.16/ /usr/local/mysql [root@mysql mysql-5.5.16]# readlink /usr/local/mysql /usr/local/mysql-5.5.16/ [root@mysql mysql-5.5.16]#

        7、配置環境

        [root@mysql mysql-5.5.16]# cd … [root@mysql tools]# echo ‘export PATH=/usr/local/mysql/bin:$PATH' >>/etc/profile  [root@mysql tools]# tail -1 /etc/profile export PATH=/usr/local/mysql/bin:$PATH  [root@mysql tools]# source /etc/profile [root@mysql tools]# echo $PATH /usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin [root@mysql tools]#

        8、拷貝、查看、設置屬主、及添加tmp權限

        [root@mysql tools]# cp mysql-5.5.16/support-files/my-small.cnf /etc/my.cnf [root@mysql tools]# ll /usr/local/mysql/data/ total 0 drwxr-xr-x 2 root root 20 May 31 11:51 test [root@mysql tools]# chown -R mysql.mysql /usr/local/mysql/data/ [root@mysql tools]# chmod -R 1777 /tmp/ [root@mysql tools]#

        9、初始化數據庫

        [root@mysql tools]# cd /usr/local/mysql/scripts/ [root@mysql scripts]# ./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysql Installing MySQL system tables… OK Filling help tables… OK

        注:看到兩個ok表示成功

        10、設置開機啟動

        [root@mysql scripts]# cd /roottools/mysql-5.5.16 [root@mysql mysql-5.5.16]# cp support-files/mysql.server /etc/init.d/mysqld [root@mysql mysql-5.5.16]# chmod -R 755 /etc/init.d/mysqld [root@mysql mysql-5.5.16]# chkconfig --add mysqld [root@mysql mysql-5.5.16]# chkconfig mysqld on [root@mysql mysql-5.5.16]# chkconfig --list mysqld  Note: This output shows SysV services only and does not include native systemd services. SysV configuration data might be overridden by native systemd configuration.  If you want to list systemd services use ‘systemctl list-unit-files'. To see services enabled on particular target use ‘systemctl list-dependencies [target]'. mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off [root@mysql mysql-5.5.16]#

        11、啟動mysql數據庫

        [root@mysql mysql-5.5.16]# /etc/init.d/mysqld start Starting MySQL… SUCCESS! [root@mysql mysql-5.5.16]#

        12、查看端口進程

        [root@mysql mysql-5.5.16]# lsof -i:3306 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME mysqld 51146 mysql 10u IPv4 82600 0t0 TCP :mysql (LISTEN) [root@mysql mysql-5.5.16]# netstat -lnutp|grep 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0: LISTEN 51146/mysqld [root@mysql mysql-5.5.16]# ps -ef|grep 3306 mysql 51146 50900 0 14:13 pts/1 00:00:00 /usr/local/mysql-5.5.16/bin/mysqld --basedir=/usr/local/mysql-5.5.16 --datadir=/usr/local/mysql-5.5.16/data --plugin-dir=/usr/local/mysql-5.5.16/lib/plugin --user=mysql --log-error=/usr/local/mysql-5.5.16/data/mysql.err --pid-file=/usr/local/mysql-5.5.16/data/mysql.pid --socket=/usr/local/mysql-5.5.16/tmp/mysql.sock --port=3306 root 51170 16240 0 14:14 pts/1 00:00:00 grep --color=auto 3306 [root@mysql mysql-5.5.16]#

        注:如果要重新初始化只要刪除data目錄庫文件存儲地或者新建一個庫文件存儲地,重新初始化,提示兩個ok就是成功

        進入數據庫

        [root@localhost ~]# mysql

        查看所有用戶

        mysql> use mysql mysql> show tables; mysql> select user,host from user;

        刪除系統默認的

        delete from mysql.user where user=''; delete from mysql.user where host='::1'; select user,host from mysql.user;

        只保留這兩個

        mysql> select user,host from mysql.user; ±-----±----------+ | user | host | ±-----±----------+ | root | 127.0.0.1 | | root | localhost | ±-----±----------+ 2 rows in set (0.00 sec)  mysql> #########################

        添加額外的授權管理員用戶

        grant all privileges on . to system@‘192.168.%' identified by ‘system' with grant option;

        字符集路徑

        vi /etc/locale.conf #centos7

        mysql創建密碼

        /application/mysql//bin/mysqladmin -u root password ‘123456'

        mysql修改密碼

        /application/mysql//bin/mysqladmin -u root -p123456 password ‘112233'

        贊(0)
        分享到: 更多 (0)
        網站地圖   滬ICP備18035694號-2    滬公網安備31011702889846號
        主站蜘蛛池模板: 久久精品国产黑森林| 亚洲欧洲精品无码AV| 亚洲AV永久无码精品网站在线观看| 久久福利青草精品资源站| 亚洲人成精品久久久久| 国产一区精品| 97精品在线播放| 国内精品久久国产大陆| 精品无码人妻一区二区免费蜜桃| 另类国产精品一区二区| 中文字幕亚洲精品| 国产午夜精品视频| 大伊香蕉精品一区视频在线 | 免费精品精品国产欧美在线欧美高清免费一级在线 | 亚洲中文字幕久久精品无码APP | 国产精品自产拍高潮在线观看| 久久96国产精品久久久| 97久久超碰成人精品网站| 人妻AV一区二区三区精品| 伊人精品视频在线| 欧美激情精品久久久久久| 精品一久久香蕉国产线看播放| 国产精品视频免费一区二区| 91精品国产91久久久久久| 久久久91精品国产一区二区三区 | 国产成人精品电影在线观看| 久久66热人妻偷产精品9| 日韩精品无码熟人妻视频| 日韩精品无码熟人妻视频 | 亚洲日韩精品无码专区网站| 日韩精品欧美亚洲| 亚洲欧洲精品成人久久奇米网| 亚洲日韩国产AV无码无码精品| 小辣椒福利视频精品导航| 亚洲AV日韩精品久久久久久| 久久永久免费人妻精品下载| 国产亚洲精品资源在线26u| 99精品视频3| 6080亚洲精品午夜福利| 国产精品小黄鸭一区二区三区| 久久精品国产WWW456C0M|