mysql数据库使用探索.docxVIP

一．MYSQL登录错误：mysqladmin: connect to server at ‘localhost’ failed一、mysql登录错误mysqladmin:?connect?to?server?at?localhost?failed???????error:?Access?denied?for?user?root@localhost?(using?password:?YES)解决办法：破解mysql密码#?service?mysqld?stop???????#mysqld_safe?--skip-grant-tables????????输入?mysql?-uroot?-p?回车进入???????use?mysql;????????update?user?set?password=PASSWORD(newpass)where?user=root;???????更改密码为?newpassord????????flush?privileges;?更新权限????????quit?退出service?mysqld?restart???????mysql?-uroot?-p新密码进入?二，忘记本地root的登录密码解决过程：1、编辑/etc/f在[mysqld]?配置部分添加一行skip-grant-tables?2、保存后重启mysql[root@localhost?etc]#?service?mysqld?restartShutting?down?MySQL.?????????????????????????????????????????[??OK??]Starting?MySQL.???????????????????????????????????????????????????[??OK??]3、登录数据库重新设置root密码[root@localhost?~]#?mysql?-uroot?-p?mysqlEnter?password:直接回车进入Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?\g.Your?MySQL?connection?id?is?1Server?version:?5.1.47-log?Source?distributionCopyright?(c)?2000,?2010,?Oracle?and/or?its?affiliates.?All?rights?reserved.This?software?comes?with?ABSOLUTELY?NO?WARRANTY.?This?is?free?software,and?you?are?welcome?to?modify?and?redistribute?it?under?the?GPL?v2?licenseType?help;?or?\h?for?help.?Type?\c?to?clear?the?current?input?statement.mysql?show?databases;+--------------------+|?Database???????????|+--------------------+|?information_schema?||?mysql??????????????||?test???????????????|+--------------------+3?rows?in?set?(0.00?sec)执行下列语句mysql?update?user?set?password=password(mysql)?where?user=root;Query?OK,?4?rows?affected?(0.00?sec)Rows?matched:?4??Changed:?4??Warnings:?0mysql?flush?privileges;Query?OK,?0?rows?affected?(0.00?sec)?4、删除/etc/f文件中添加的“skip-grant-tables”行，重启mysql；用新设的密码就能正常登录了；二．MySql ERROR 1046(3D000): No Database Selected没有选择数据库！?首先建立数据库，再在其中建立数据表：create database （database name）use （database name）即可。三．ERROR 1146 (42S02): Table mysql.slow_log doesnt exist去查看最新的slow log，发现没有最新的记录，上去检查slow log是否开启了。?mysql show variables like %slow%;+------