Centos使用yum安装mysql
centos安装mysql
+-----------------------------------------+
http://51hired.com/questions/3300/yum%E5%AE%89%E8%A3%85MySQL%E5%B9%B6%E8%AE%BE%E7%BD%AE%E5%AF%86%E7%A0%81
yum安装mysql并设置密码
yum install mysql
yum install mysql-server
yum install mysql-devel
chgrp -R mysql /var/lib/mysql
chmod -R 770 /var/lib/mysql
service mysqld start
mysql
SET PASSWORD FOR 'root'@'localhost' = PASSWORD ('123456')
#为数据库设置密码
ok,安装mysql完毕
为了让其他机器都访问,在Mysql.user中添加一个'Host'为'%'的user,然后flush priviledges;最后防火墙加上一句类似这样的语句即可(开通3306端口)
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
然后要reboot自启动
chkconfig --level 345 mysql on
+------------------------------------------------------------------------+
centos下面安装sqlite
1.下载大安装包,然后将其上传到服务器上
2.使用tar -xzvf sqlite
3.转到sqlite目录上
4.然后./configure --disable -tcl #加上这个选项则不需要TCL,否则在2.4内核上面编译不通过
5.make
6.make install
另外:
如果make的时候提示错误:
测试是否安装成功
#cd /usr/local/sqlite
# ./sqlite3 text.db
则会出现了成功提示
+----------------------------------------------------------------------------------------+
mysql> SHOW CREATE TABLE fuinfo
-> ;
+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| fuinfo | CREATE TABLE `fuinfo` (
`fid` int(10) unsigned NOT NULL,
`name` varchar(40) NOT NULL,
`email` varchar(128) NOT NULL,
UNIQUE KEY `email` (`email`),
UNIQUE KEY `fid` (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
如何删除其中的email索引:
alter table fuinfo drop index email;