补充:安装之前要彻底卸载mysql数据库,如果是ubuntu,可参考下面的安装步骤:
1
sudo apt
-
get autoremove
--
purge mysql
-
server
-
5.0
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 如果上面任一试验成功,则注册服务成功