MySQL中设置自增字段
Posted Aug 16th, 2008 by askie
MySQL中设置自增字段
alter table album change ALBUM_ID ALBUM_ID bigint not null auto_increment;
alter table album auto_increment=1;
创建:
mysql>create table cc(id int auto_increment,name varchar(20),primary key(id));
修改:
mysql> alter table cc change id id int primary key auto_increment;
…
mysql优化脚本!
Posted Aug 16th, 2008 by askie
[mysqld]
#port = 3306
#socket = /tmp/mysql.sock
#socket = /var/lib/mysql/mysql.sock
#skip-locking
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
net_buffer_length = 16K
myisam_sort_buffer_size = 1M
max_connections=120
#addnew config
wait_timeout =120…
mysql随机查询输出数据语句
Posted Jul 28th, 2008 by askie
原来以为mysql没有随机输出数据的方法呢,google后还是搜索到了结果,代码如下:
select * from tablename order by rand() limit 10
MySQL修改root密码的多种方法
Posted Apr 21st, 2008 by askie
方法1: 用SET PASSWORD命令
mysql -u root
mysql> SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(’newpass’);
方法2:用mysqladmin
mysqladmin -u root password “newpass”
如果root已经设置过密码,采用如下方法
mysqladmin -u root password oldpass “newpass”
方法3: 用UPDATE直接编辑user表
mysql -u root
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD(’newpass’) WHERE user = ‘root’;
mysql> FLUSH PRIVILEGES;
在丢失root密码的时候,可以这样
mysqld_safe –skip-grant-tables&
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD(”new password”) WHERE user=’root’;
mysql> FLUSH PRIVILEGES;
相关文章:
linux下手动安装pdo_mysql
解决不能通过mysql.sock连接MySQL问题
MySQL中设置自增字段
让mysql 与 apache [...]