Home > Backend Development > PHP Tutorial > 一段PhpMyAdamin导出的sql语句,

一段PhpMyAdamin导出的sql语句,

WBOY
Release: 2016-06-13 13:48:25
Original
937 people have browsed it

一段PhpMyAdamin导出的sql语句,请指教!
CREATE   DATABASE   IF   NOT   EXISTS   primavpdb001   ;
GRANT   ALL
        ON   primavpdb001.*
        TO   primavpdb001_f@localhost
        IDENTIFIED   BY   'changeme '   ;
FLUSH   PRIVILEGES   ;

USE   primavpdb001;

这段语句,请教各位了!详细点更好,嘿嘿!

------解决方案--------------------
CREATE DATABASE IF NOT EXISTS primavpdb001 ;
检查数据库primavpdb001是否存在,不存在则创建


GRANT ALL
ON primavpdb001.*
TO primavpdb001_f@localhost
IDENTIFIED BY 'changeme ' ;
FLUSH PRIVILEGES ;
赋予用户primavpdb001_f在localhost上对primavpdb001数据库中所有数据表的全局权限,密码设置为changeme

USE primavpdb001;
打开数据库primavpdb001

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template