摘要： 阅读全文

摘要：netstat命令是一个监控TCP/IP网络的非常有用的工具，它可以显示路由表、实际的网络连接以及每一个网络接口设备的状态信息输出结果可以分为两个部分，一个是Active Internet connections，另一个是Active UNIX domain sockets.[root@DBSVR02 conf]# netstatActive Internet connections (w/o servers)Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 168.168.80.9:ssh 168.168.80.1 阅读全文

摘要：mysql> create table ss(id int unsigned not null primary key auto_increment, user_name varchar(15) not null);Query OK, 0 rows affected (0.00 sec)mysql> mysql> insert into ss(id,user_name) values(1, 'jojo');Query OK, 1 row affected (0.00 sec)mysql> insert into ss(id,user_name) valu 阅读全文

摘要：[root@DBSVR01 e]# service mysqld statusmysqld is stopped[root@DBSVR01 e]#==================================[root@DBSVR01 e]# service mysqld startInitializing MySQL database: Installing MySQL system tables...OKFilling help tables...OKTo start mysqld at boot time you have to copysupport-files/mysql.se 阅读全文

摘要：[root@DBSVR01 e]# mysql -uroot -pEnter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)[root@DBSVR01 e]#=======================删除user.user中值为NULL的,或更新NULL为test 1)delete from user where user is NULL 2)update user set user=‘test‘ where user 阅读全文

摘要：[root@DBSVR01 e]# which mysql/usr/bin/mysql[root@DBSVR01 e]# whereis mysqlmysql: /usr/bin/mysql /usr/lib/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz[root@DBSVR01 e]# 阅读全文

摘要：[root@DBSVR01 e]# yum install mysql.i686Loaded plugins: fastestmirror, securityLoading mirror speeds from cached hostfile* base: centos.ustc.edu.cn* extras: centos.ustc.edu.cn* updates: ftp.twaren.netSetting up Install ProcessResolving Dependencies--> Running transaction check---> Package mysq 阅读全文

摘要：The type or namespace name 'MySql' could not be found 阅读全文