易截截图软件、单文件、免安装、纯绿色、仅160KB

如何重启MySQL服务

 RedHat Linux (Fedora Core/Cent OS)
1.启动:/etc/init.d/mysqld start
2.停止:/etc/init.d/mysqld stop
3.重启:/etc/init.d/mysqld restart
Debian / Ubuntu Linux
1.启动:/etc/init.d/mysql start
2.停止:/etc/init.d/mysql stop
3.重启:/etc/init.d/mysql restart
Windows
1.点击“开始”->“运行”(快捷键Win+R)
2.启动:输入 net stop mysql
3.停止:输入 net start mysql
提示
Redhat Linux 也支持service command,
启动:# service mysqld start
停止:# service mysqld stop
重启:# service mysqld restart
Windows下不能直接重启(restart),只能先停止,再启动。


相关文档:

MySQL: Connect MySQL GUI tools to WAMP 2.0

Connect MySQL GUI tools to WAMP 2.0 Posted by: Vladislav Sadykov () Date: January 24, 2009 09:31AM Hay, I have a problem with MySQL database. I have installed WAMP 2.0 server on my Windows machine and now I would like to connect it with MySQL GUI tools 5. The problem is that at the startup of ......

mysql报错

报错:
 /tmp/ccBBJEB8.o: In function `ping_sql':
pingsql.c:(.text+0x7c): undefined reference to `mysql_init'
pingsql.c:(.text+0xe1): undefined reference to `mysql_real_connect'
pingsql.c:(.text+0xff): undefined reference to `mysql_close'
pingsql.c:(.text+0x119): undefined reference to `mys ......

mysql中文乱码

第一步:修改数据库配置文件my.ini
客户端的默认字符编码:
default-character-set=utf8
服务器端的默认字符编码
default-character-set=utf8
第二步:重新启动mysql数据库
net stop mysql
net start mysql
第二步:修改applicationContent.xml
修改url属性,将其改为:jdbc:mysql://localhost:3306/member?useUni ......

快速重置MySQL用户密码

 
1、停止正在运行的MySQL进程
    
Linux下,运行 killall -TERM mysqld
     Windows下,如果写成服务的可以运行:net stop mysql,如未加载为服务,可直接在任务管  理器中进行关闭。
2、以安全模式启动MySQL
    
Linux下,运行 mysqld_sa ......

mysql替换数据库中的部分内容

  例子:将cdb_pms表subject字段中的Welcom to替换成 欢迎光临
UPDATE `cdb_pms`
SET `subject` = REPLACE(`subject`, ‘Welcome to’, ‘欢迎光临’)
WHERE INSTR(`subject`,’Welcome to’) < 0 替换cdb_posts表的message字段,将“viewthread.php?tid=3989”替换成“viewthread.php?tid=16546” U ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号