本文参考mysql官方文档,和一点自己的自由发挥。。。
首先需要下载mysql的tar包
地址:http://dev.mysql.com/downloads/file.php?id=450325
也可以自己去官网 自己找下载地址,选择版本时注意:
操作系统选择 linux Generic
mysql版本选择 Linux - Generic (glibc 2.5) (x86, 64-bit), Compressed TAR Archive
软件会自动下载到Downloads文件夹
切换到Downloads下
cd Downloads
解压下载的mysql包
sudo tar zxvf mysql-5.6.15-linux-glibc2.5-x86_64.tar.gz
将解压后的文件夹移动到usr/local文件夹下
sudo mv mysql-5.6.15-linux-glibc2.5-x86_64 /usr/local
切换到/usr/local文件夹
cd /usr/local
为 mysql-5.6.15-linux-glibc2.5-x86_64 文件夹创建软连接
sudo ln -s mysql-5.6.15-linux-glibc2.5-x86_64/ mysql
将mysql文件夹的权限赋给当前用户,我基本上所有的软件的权限都赋给了一个用户,省的麻烦
sudo chown -R hadp:hadoop mysql/
切换到mysql文件夹
cd mysql
接着执行下面的命令,根据官方文档,是建立grant table 用户表
sudo scripts/mysql_install_db
如果遇到下面的错误:
error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
解决方法,下载所要的包:
sudo apt-get install libaio1 libaio-dev
然后重新执行
sudo scripts/mysql_install_db
执行完后最后又这么一个提示,意思就是 my.cnf是原来自带的,你在自己系统上装Mysql后又会生成一个新的my-new.cnf,比较他们两个的不同,合并为一个my.cn
现在先不管它,因为要等mysql启动的时候才会出来my-new.cnf
WARNING: Found existing config file ./my.cnf on the system.
Because this file might be in use, it was not replaced,
but was used in bootstrap (unless you used --defaults-file)
and when you later start the server.
The new default config file was created as ./my-new.cnf,
please compare it with your file and take the changes you need.
切换到根目录
cd ~
编辑 .bashrc文件
sudo vim .bashrc
在文件末尾添加如下内容
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
切换到mysql文件夹下,修改my.cnf的内容
cd /usr/local/mysql
sudo vim my.cnf
将下列变量前的#去掉,并赋值
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
basedir =/usr/local/mysql
datadir = /usr/local/mysql/data
# port = .....
# server_id = .....
# socket = .....
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
切换到mysql文件夹下的data文件夹,更改data文件夹权限
cd data
sudo chown -R hadp:hadoop data
启动mysql服务器
mysqld
在最后输出这条提示就说明安装成功了。
启动一个新的终端
连接mysql服务器
mysql -u root -p
提示输入密码,不要输入,直接回车就会连接上mysql,因为初始密码为空
出现 mysql> 就说明进入mysql了
使用如下命令查看数据库信息
show databases;
从用户表中选择显示用户名密码
select User,Password from user 显示如下,root却是还没有密码,需要用户自己设定
断开mysql 连接
exit
停止mysql服务器
mysqladmin shutdown -u root -p