centos5.5 mysql5.0
yum安装:
1.centos5.5操作系统下使用yum,命令:yum install mysql-server
2.启动mysql,命令:/etc/init.d/mysqld start 或 service mysqld start
3.修改root密码:命令:mysqladmin -u root password 密码
4.进入mysql:命令:mysql -u root -p
*****************************************************
源码安装:
Centos5.5 mysql5.5.30
mysql下载:
http://dev.mysql.com/downloads/mysql/
http://dev.mysql.com/doc/
依赖工具:
gcc
gcc-c++
cmake
make
ncurses
ncurses-devel
bison
bison-devel
上述软件如没有,须安装,一般安装光盘内都有。其中cmake未能找到,可下载源码编译安装。
可到http://www.cmake.org下载,如cmake-2.8.10.2.tar.gz,编译前应先安装c++编译器,
cd cmake-2.8.10.2
./configure
make
make install
依赖软件安装好后,可安如下步骤:
# Preconfiguration setup
shell> groupadd mysql
shell> useradd -r -g mysql mysql
# Beginning of source-build specific instructions
shell> tar zxvf mysql-VERSION.tar.gz
shell> cd mysql-VERSION
shell> cmake .
shell> make
shell> make install
# End of source-build specific instructions
# Postinstallation setup
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
# Next command is optional
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> bin/mysqld_safe --user=mysql &
# Next command is optional
shell> cp support-files/mysql.server /etc/init.d/mysql.server
cmake编译出现ERROR后,再编译先执行:
shell> make clean
shell> rm CMakeCache.txt
编译安装好后,设置mysql环境变量
vi /etc/profile
添加: PATH=/usr/local/mysql/bin:$PATH
再执行:source /etc/profile
******************************************************************************
使用LINUX命令行模式下,如显示内容大须分页显示可用如下命令
开启:
mysql>pager more; 或 \P more;
或
mysql>pager less; 或 \P less;
关闭:
nopager;
mysql操作:
1.显示数据库列表
show databases;
2.切换数据库
use database;
3.显示数据库中表,须先切换至数据库
show tables;
4.显示表结构
desc tablename;
show columns from tablename;
设置Mysql编码
mysql>show variables like '%character%' //查看当前使用的编码
查看/etc/my.cnf文件,如果是简略版本,可复制
cp /usr/share/doc/mysql-server-*/my-large.cnf /etc/my.cnf
然后
vi /etc/my.cnf
添加
[client]下
default-character-set=utf8
[mysqld]下
default-character-set=utf8 //如果报unknown variable 'default-character-set=utf8',可改为character-set-server=utf8
再重启一下mysql
service mysqld restart