mysql server安装
三. mysql server安装
------------------以下为扩展：删除mysql----------------
删除 mysql
sudo apt-get autoremove --purge mysql-server-5.0
sudo apt-get remove mysql-server
sudo apt-get autoremove mysql-server
sudo apt-get remove mysql-common //这个很重要 应该为自动删除autoremove
上面的其实有一些是多余的。
清理残留数据
dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P
--------------------扩展完毕--------------------------
1. mysql server安装
1.sudo apt-get install mysql-server mysql-client
2.输入root密码为root
3.更改mysql最大连接数：
sudo gedit /etc/mysql/my.cnf 增加或修改max_connections=1024;
2.进入mysql:
sudo mysql –u root -p 输入密码root进入。
3.添加/删除权限
语法如下：
grant all privileges(or other options) on *.* (or others) to username@"localhost( or % or otherIP)" identified by"username" (or with grant option);若with grant option则为超级用户。
revoke all privileges (or other options) on *.* (or others) from username(or username@"localhost( or % or otherIP)");
默认安转已经为root添加了本机权限,回收权限时请慎重对root权限回收。
注：回收权限并不删除用户。如果想删除，需要delete from user where USER like '...'
加权限的用户创建：
eg:mysql>grant all privileges on epaper.* to wenxin@'localhost' identified by 'xinwen365'; 意思是:允许wenxin从本地访问epaper数据库并且具有对该数据库的所有操作
mysql>grant all privileges on epaper.* to wenxin@'%' identified by 'xinwen365'; &nbs
相关文档：
Starting the cluster is not very difficult after it has been configured. Each cluster node process must be started separately, and on the host where it resides. The management node should be started first, followed by the data nodes, and then finally by any SQL nodes:
On the management host, issu ......
To shut down the cluster, enter the following command in a shell
on the machine hosting the management node:
shell> ndb_mgm -e shutdown
The -e
option here is used to pass a command to
the ndb_mgm
client from the shell. (See
Section 4.23, “ ......
If you set it in the cnf(it may be my.ini file) you will likely need to restart the server. Optionally, that is a dynamic variable and can be SET GLOBAL or SET SESSION from the command line as well.So just do as follows.
mysql>show variables like’max_allowed_packet’;
......
Oracle 8 資料庫函式庫
OCIDefineByName
讓 SELECT 指令可使用 PHP 變數。
語法: boolean OCIDefineByName(int stmt, string ColumnName, mixed &variable, int [type]);
傳回值: 布林值
函式種類: 資料庫功能
內� ......
表设计方面：
1、字段名尽量简化，不要超过18个字符
2、使用尽量小的数据类型，例如：MEDIUMINT比INT少占用25%空间
3、字段类型应尽量避免设置成可变长度，如：VARCHAR、BLOB、TEXT
4、用于比较的不同字段，应设置相同的类型及长度
5、尽可能将字段声明为NOT NULL，并指定DEFAULT
6、主索引尽可能短
7、仅创建真正 ......
