1.下载mysql-5.5.50-linux2.6-x86_64.tar.gz
2.解压缩到/usr/local/work下
tar zxvf mysql-5.5.50-linux2.6-x86_64.tar.gz
3. mv mysql-5.5.50-linux2.6-x86_64 /usr/local/
4. cd /usr/local
mv mysql-5.5.50-linux2.6-x86_64 mysql
5.cd /usr/local/mysql
./scripts/mysql_install_db
chown -R mysql /usr/local/mysql
chgrp -R mysql /usr/local/mysql
6.启动mysql
/usr/local/mysql/bin/mysqld_safe &
7.增加连接/tmp/mysql.sock
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
8.系统自动启动的mysql
cp support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
chkconfig –add mysql
9.测试
cd ./mysql-test ; perl mysql-test-run.pl
10.用客户端连接
mysql -uroot -p
此时没有密码
create database mytest;
show database;
create table student (id int(10) auto_increment primary key,
name varchar(100),
note varchar(100)
);
show tables;
insert into student (name,note) values(‘测试007’,’测试说明’);
select * from student;