1>安装mysql服务器:
groupadd mysql
useradd -g mysql mysql
cd /usr/local
gunzip < /usr/local/mysql-5.0.41-linux-i686.tar.gz | tar xvf -
ln -s mysql-5.0.41-linux-i686 mysql
cd mysql
chown -R mysql .
chgrp -R mysql .
scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data
bin/mysqld_safe --user=mysql &
2>设置mysql自动启动
cp ./support-files/mysql.server /etc/rc.d/init.d/mysql
chmod +x /etc/rc.d/init.d/mysql
/sbin/chkconfig --level 3 mysql on
3>修改库的位置,使得编译mysql++时能找到mysql的类库
vim /etc/ld.so.conf
加入/usr/local/mysql/lib和/usr/local/lib
ldconfig
4>拷贝mysql的头文件
cp -R mysql/include/ /usr/include/mysql
5>编译安装mysql++
./configure
make
make install
6>使用mysql服务器
登录服务器:
mysql/bin>./mysql -u root -p
改密码:
use mysql
update user set Password=password('newpassword') where User='root';
flush privileges;
开放远程访问:
update user set host = '%' where user = 'root';
groupadd mysql
useradd -g mysql mysql
cd /usr/local
gunzip < /usr/local/mysql-5.0.41-linux-i686.tar.gz | tar xvf -
ln -s mysql-5.0.41-linux-i686 mysql
cd mysql
chown -R mysql .
chgrp -R mysql .
scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data
bin/mysqld_safe --user=mysql &
2>设置mysql自动启动
cp ./support-files/mysql.server /etc/rc.d/init.d/mysql
chmod +x /etc/rc.d/init.d/mysql
/sbin/chkconfig --level 3 mysql on
3>修改库的位置,使得编译mysql++时能找到mysql的类库
vim /etc/ld.so.conf
加入/usr/local/mysql/lib和/usr/local/lib
ldconfig
4>拷贝mysql的头文件
cp -R mysql/include/ /usr/include/mysql
5>编译安装mysql++
./configure
make
make install
6>使用mysql服务器
登录服务器:
mysql/bin>./mysql -u root -p
改密码:
use mysql
update user set Password=password('newpassword') where User='root';
flush privileges;
开放远程访问:
update user set host = '%' where user = 'root';