64位CentOs6.5系统阿里云服务器源码安装MySql5

• 演示MySql版本： 5.5.44

  阿里云服务器操作系统：64位CentOs6.4

  上传目录：/home/downloads

  百度网盘下载地址： http://pan.baidu.com/s/1kTNNE8R

  关注微信公共号：云主机服务器租用，回复关键词“ftp”查看上传方法，回复“linux远程桌面”查看linux远程管理服务器方法

  预安装操作:

  cd /home

  mkdir mysql

  yum install cmake

  yum install bison

  yum install perl

  yum install git

  yum install gcc-c++

  yum install ncurses-devel

  cd /home/mysql

  mkdir data

  mkdir log

  mkdir run

  cd run

  mkdir mysqld

  useradd -d /home/mysql -g wheel mysql

  chown -fR mysql /home/mysql

  源码安装Mysql：

  cd /home/downloads

  tar -xvf mysql-5.5.44.tar.gz

  cd mysql-5.5.44

  mkdir bld

  cd bld

  cmake .. -DCMAKE_INSTALL_PREFIX=/home/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_DATADIR=/home/mysql/data -DMYSQL_USER=mysql

  make

  make install

  cd /home/mysql/

  scripts/mysql_install_db

  vi /etc/my.cnf

  [mysqld]

  datadir=/home/mysql/data

  socket=/tmp/mysql.sock

  user=mysql

  # Disabling symbolic-links is recommended to prevent assorted security risks

  symbolic-links=0

  [mysqld_safe]

  log-error=/home/mysql/log/mysqld.log

  pid-file=/home/mysql/run/mysqld/mysqld.pid

  [client]

  socket=/tmp/mysql.sock

  su – mysql

  bin/mysqld_safe &

  bin/mysqladmin -u root password ‘test123456'

  Mysql常见操作命令：

  连接数据库:/home/mysql/bin/mysql –uroot -p

  启动数据库:

  su – mysql

  bin/mysqld_safe &

  关闭数据库: /home/mysql/bin/mysqladmin –uroot –p shutdown

  导出数据：/home/mysql/bin/mysqldump –uroot –p test >test.sql

  修改用户权限，允许远程连接数据库：

  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin123' WITH GRANT OPTION;

  flush privileges;

视屏地址如下：http://www.51yunzhuji.com/a-li-yun-fu-wu-qi-jiao-cheng-faq-2411.html#