Skip to content

Category Archives: mysql

mysql优化脚本！

16-Aug-08

[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…

Also filed in LAMP | Tagged , , | Comments (1) »

mysql随机查询输出数据语句

28-Jul-08

原来以为mysql没有随机输出数据的方法呢，google后还是搜索到了结果，代码如下：
select * from tablename order by rand() limit 10

Also filed in | Tagged , , , | Comments (6) »

MySQL修改root密码的多种方法

21-Apr-08

方法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 [...]

Also filed in | | Comments (0) »