MySql学习

１。下载mysql-5.6.22-winx64
　　开始——运行——cmd，然后cd到mysql安装目录的bin下面，我的目录就是“C:\Program Files\mysql-5.6.22-win32\bin”，然后执行mysqld -install,提示服务安装成功！运行services.msc一看，确实有一个名为MySQL的服务了，启动它。有时启动失败，根据情况调整参数即可。
　　cd到bin目录下，然后执行“mysql -u root -p”，提示输入密码，由于第一次运行，密码为空可以直接回车。
　　运行"show variables like '%version%'" 查看数据库相关信息
　　修改MySQL的root用户密码格式：mysqladmin -u用户名 -p旧密码 password 新密码，试过不成功!
       MySQL>update MySQL.user set password=password("123456") where user='root';
       MySQL>flush privileges;
       这样就可以了
　　MySQL>quit
       MySQL>MySQL -u root -p
       Enter password:123456

2.mysql安装完成后默认只能本机(就是localhost)登录, 我们需要开启远程登录才方便使用
x:\>mysql -u root -p 密码   //登录系统
mysql> use mysql;       //切换数据库
mysql> update user set host = '%' where user = 'root'; 
//上面这句话有时出现一个错误  ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'

//不过这时你查询一下user表发现已经更新一条记录了,下面这句话
mysql> select host, user from user;

//直接执行这句,其实就是刷新权限
mysql> flush privileges;

MySQL>insert into mysql.user(host,user,password,ssl_cipher,x509_issuer,x509_subject) values('localhost',root',password('123456'),'N','N','N');

mysql>update MySQL.user set Host='localhost',select_priv='y', insert_priv='y',update_priv='y', Alter_priv='y',delete_priv='y',create_priv='y',drop_priv='y',reload_priv='y',shutdown_priv='y',Process_priv='y',file_priv='y',grant_priv='y',References_priv='y',index_priv='y',create_user_priv='y',show_db_priv='y',super_priv='y',create_tmp_table_priv='y',Lock_tables_priv='y',execute_priv='y',repl_slave_priv='y',repl_client_priv='y',create_view_priv='y',show_view_priv='y',create_routine_priv='y',alter_routine_priv='y',create_user_priv='y' where user='root';

3.如果不小心修改mysql.user把权限去掉了

在my.ini里加上这２句
[mysqld] 

explicit_defaults_for_timestamp=1

skip-grant-tables

然后重启mysql服务
mysql> update MySQL.user set Host='localhost',select_priv='y', insert_priv='y',update_priv='y', Alter_priv='y',delete_priv='y',create_priv='y',drop_priv='y',reload_priv='y',shutdown_priv='y',Process_priv='y',file_priv='y',grant_priv='y',References_priv='y',index_priv='y',create_user_priv='y',show_db_priv='y',super_priv='y',create_tmp_table_priv='y',Lock_tables_priv='y',execute_priv='y',repl_slave_priv='y',repl_client_priv='y',create_view_priv='y',show_view_priv='y',create_routine_priv='y',alter_routine_priv='y',create_user_priv='y' where user='root';

mysql> flush privileges;
然后注释
＃skip-grant-tables
再次重启mysql服务，就有权限了

4.下载phpmyadmin
http://www.phpmyadmin.net/downloads/

配置好php,MySQL,打开

http://localhost/phpmyadmin/setup/

http://jingyan.baidu.com/article/ab0b5630b130d4c15afa7dc2.html

PHP Fatal error: Call to undefined function mb_detect_encoding() in
E:\Site\phpMyAdmin\libraries\php-gettext\gettext.inc on line 177

PHP Fatal error: Uncaught Error: Call to undefined function mb_detect_encoding() in D:\Inetpub\wwwroot\phpMyAdmin-4.6.2-all-languages\phpMyAdmin-4.6.2-all-languages\libraries\php-gettext\gettext.inc:177 Stack trace: #0 D:\Inetpub\wwwroot\phpMyAdmin-4.6.2-all-languages\phpMyAdmin-4.6.2-all-languages\libraries\php-gettext\gettext.inc(282): _encode('The %s extensio...') #1 D:\Inetpub\wwwroot\phpMyAdmin-4.6.2-all-languages\phpMyAdmin-4.6.2-all-languages\libraries\php-gettext\gettext.inc(289): _gettext('The %s extensio...') #2 D:\Inetpub\wwwroot\phpMyAdmin-4.6.2-all-languages\phpMyAdmin-4.6.2-all-languages\libraries\core.lib.php(306): __('The %s extensio...') #3 D:\Inetpub\wwwroot\phpMyAdmin-4.6.2-all-languages\phpMyAdmin-4.6.2-all-languages\libraries\core.lib.php(959): PMA_warnMissingExtension('mbstring', true) #4 D:\Inetpub\wwwroot\phpMyAdmin-4.6.2-all-languages\phpMyAdmin-4.6.2-all-languages\libraries\common.inc.php(102): PMA_checkExtensions() #5 D:\Inetpub\wwwroot\phpMyAdmin-4.6.2-all-languages\phpMyAdmin-4.6.2-all-languages\i in D:\Inetpub\wwwroot\phpMyAdmin-4.6.2-all-languages\phpMyAdmin-4.6.2-all-languages\libraries\php-gettext\gettext.inc on line 177

打开php目录

用记事本打开php.ini

做如下修改:

取消以下配置参数前面的分号

extension_dir =".\ext"    #设置php模块路径为同目录下ext文件夹

register_globals= On    #开启GET数据调用

short_open_tag =On    #php支持短标签

cgi.force_redirect= 0    #开启以CGI方式运行php

fastcgi.impersonate= 1

cgi.rfc2616_headers= 1

extension=php_mbstring.dll

extension=php_mysql.dll

extension=php_mysqli.dll

extension=php_pdo_mysql.dll

有提示要PHP5.5以上

5.config for phpMyAdmin

phpMyAdmin “Cannot load or save configuration”

在根目录下创建一个folder，名为config，授予一定的权限

重启IIS

http://localhost/pma/

这里出现登陆界面，需要先指定mysql server，然后才能用DB user/password登陆
http://localhost/pma/setup/