MySql基础(1)

alexzhu99

环境redhat 5.2
一、使用源码包安装Mysql
   shell> groupadd mysql    shell> useradd -g mysql mysql shell> tar -xzvf mysql-5.0.18.tar.gz  shell> cd  mysql-5.0.18
shell> ./configure --prefix=/usr/local/mysql --with-charset=gb2312
shell> makeshell> make installshell> cp support-files/my-medium.cnf /etc/my.cnfshell> cd /usr/local/mysqlshell> bin/mysql_install_db --user=mysql       用mysql_install_db创建MySQL授权表 shell> chown -R root  .shell> chown -R mysql varshell> chgrp -R mysql .shell> bin/mysqld_safe --user=mysql &     后台启动MySQL二、连接和操作。shell> mysqlmysql> SHOW DATABASES;mysql> USE testDatabase changed创建并选择数据库mysql>CREATE DATABASE zwt;Query OK, 1 row affected (0.03 sec)mysql> use zwt
Database changed
mysql> show tables;
Empty set (0.00 sec)

   

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u3/100649/showart_2006524.html