下载http://download.csdn.net/detail/nju2012/5956257
补充:安装之前要彻底卸载mysql数据库,如果是ubuntu,可参考下面的安装步骤:
2 sudo apt - get remove mysql - server
3 sudo apt - get autoremove mysql - server
4 sudo apt - get remove mysql - common (非常重要)
清理残留数据
dpkg - l | grep ^ rc | awk ' {print $2} ' | sudo xargs dpkg - P
开始安装:
# groupadd mysql
# useradd mysql
# tar -zxvf mysql-5.6.10.tar.gz
# cd mysql-5.6.10
# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.6 --设置安装路径(5.6起已改用cmake 安装了)
可能会遇到错误:
Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)
CMake Error at cmake/readline.cmake:83 (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.
ubuntu下解决:
#rm CMakeCache.txt
#apt-get install libncurses5-dev
上面的cmake 后,接着
#make (非常久)
#make install
进入mysql的安装目录:
/usr/local/mysql5.6/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql5.6 --datadir=/usr/local/mysql5.6/data --安装db
chown -R root .
chown -R mysql data
chown -R mysql .
bin/mysqld_safe --user=mysql &
设置环境变量
mysql_path=/usr/local/mysql5.6/ --(你的安装路径)
export PATH=$mysql_path/bin:$PATH
命令行:source /etc/profile
命令行:mysql命令直接登陆
注:如果出现Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
可在/usr/local/mysql5.6目录下修改my.cnf的socket 项 socket ='/var/run/mysqld/mysqld.sock'
修改root的的密码为root
SET PASSWORD FOR 'root'@'localhost' = password("root");
使MySQL的默认字符编码为UTF-8,在MySQL的配置文件中加入如下配置。这里修改下mysql5.6目录下的my.cnf
在mysqld段中加入
character-set-server=utf8
注册mysql服务
# cp /usr/local/mysql5.6/support-files/mysql.server /etc/init.d/mysql
# cp /usr/local/mysql5.6/support-files/my-default.cnf /etc/my.cnf
# update-rc.d mysql defaults
之后可以通过下面命令进行操作
临时重启服务:
/etc/init.d/mysql restart
临时关闭服务:
/etc/init.d/mysql stop
临时启动服务:
/etc/init.d/mysql start
如果上面任一试验成功,则注册服务成功