資料庫連接配接&資料庫程序&資料庫操作

root@webwall:/home/xiachengjiao# vi/webwall/mysql/my.cnf（看配置檔案中的參數）

root@webwall:/webwall/mysql/bin# ./mysql -u root -s /var/mysql1.sock -p

enter password: enter password:********

error 2002 (hy000): can't connect to local mysql serverthrough socket '/var/mysql1.sock' (2)

提示連不上資料庫

查找原因并解決

ps -a |grep mysql檢視資料庫程序并沒有開啟

xiachengjiao@webwall:/webwall/mysql/bin$sudo ./start.sh           開啟資料庫

[sudo] password for xiachengjiao:123456

ps -a |grep mysql  檢視資料庫程序是否開啟，如下顯示：

5466 pts/1    00:00:00 mysqld_safe

 7420pxs/1    00:00:00 mysqld_safe

 7725pxs/1    00:00:00 mysqld

 7817pxs/1    00:00:00 mysqld

提示資料庫程序已經開啟

重新連接配接資料庫

root@webwall:/webwall/mysql/bin# ./mysql -uroot -s /var/mysql1.sock -p

enter password: enter password:12wq12wq

資料庫操作如下：

mysql> show databases;

mysql> use new_db;

mysql> show tables;

mysql> use local;

mysql> select * from ww_role_t;

mysql> desc ww_role_t;

mysql> insert into ww_role_t(rolename,roledescribe, systemrole, permission) values("test","test", 1, "1111110000001111");

mysql> delete ww_role_t where rolename ="test";