linux 环境:OpenSuse
安装的mysql数据库是:mysql-5.6.4-m7
在开始安装前,先说明一下mysql-5.6.4与较低的版本在安装上的区别,从mysql-5.5起,mysql源码安装开始使用cmake了
cmake下载地址:http://www.cmake.org/cmake/resources/software.html
1 安装cmake:
1) tar -xzvf cmake-2.8.10.2.tar.gz
2) cd cmake-2.8.10.2
3) ./bootstrap
4) make
5) make install
2 安装mysql
1) unzip mysql-5.6.4-m7.tar.zip
2) tar -xzvf mysql-5.6.4-m7.tar.gz
3) cd mysql-5.6.4-m7
4) cmake .
出错,错误信息是:
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 isncurses-devel.
Call Stack (most recent call first):
cmake/readline.cmake:136 (FIND_CURSES)
cmake/readline.cmake:226 (MYSQL_USE_BUNDLED_LIBEDIT)
CMakeLists.txt:262 (MYSQL_CHECK_READLINE)
5) 安装 ncurses-devel (此处缺少的包与所安装的linux版本相关)
zypper install ncurses-devel
6) rm CMakeCache.txt
7) cmake .
8) make
9) make install
3 配置
1) 设置目录权限
cd /usr/local/mysql
chown -R root:mysql . //把当前目录中所有文件的所有者所有者设为root,所属组为mysql
chown -R mysql:mysql data
2) scripts/mysql_install_db --user=mysql
3) cp support-files/my-medium.cnf /etc/my.cnf //将mysql的启动服务添加到系统服务中
4) cpsupport-files/mysql.server /etc/init.d/mysqld
5) 启动服务
cd /etc/init.d
service mysqld start
6) 增加mysql的root用户密码
/usr/bin/mysqladmin -u root password 'newpassword'
注:在此处修改root密码的时候,网上有说使用/usr/local/mysql/bin/mysqladmin -u root password 'newpassword'
但是我执行的时候出现问题:
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
网上解释该问题是因为mysql.sock 的默认目录是在/var/lib/mysql .所以需要将该文件拷贝到 /tmp/ .如果不能拷贝,则建立软链接即可.但是在目录下 /var/lib/mysql,我这儿根本就没有文件 mysql.sock,所以就使用了上面的方式来修改root的密码
4 连接(本地连接)
有两种方式都可以:
1) mysql -u 'root'@'localhost'
2) mysql -u root -p 然后再输入密码就可以了
注: Mysql 更多信息: http://see.xidian.edu.cn/cpp/u/mysql_ml/
1) create database my_db;
2) use my_db;
3) create table .......