`

mysql common used command

阅读更多

1:connect: mysql -u root -p

 

2:change password:

use mysql
update user set Password=password('newpassword') where User='root';
flush privileges;

 

3:create database discuz;

 

4:grant all privileges on discuz.* to discuz@localhost identified by '123456';

分享到:
评论

相关推荐

    MySQL 5.6 Reference Manual

    Table of Contents Preface, Notes, Licenses . . . . . . . . ....1. Licenses for Third-Party Components ....1.1. FindGTest.cmake License ....1.2. LPeg Library License ....1.3. LuaFileSystem Library License ....

    PHP and MySQL Web Devepopment 4th Edition.pdf

    connected together by a WAN link, each of the two facilities would typically be configured to act as its own site since the computers within the facility are on a common LAN, but there is no LAN ...

    sql.assistant-5.1.10-patch

    for Oracle, SQL Server, DB2, Sybase, MS Access, PostgreSQL, and MySQL SQL Assistant integrates with many widely used database editors and database management and development environments including ...

    sql好工具sql.assistant-5.1.10

    for Oracle, SQL Server, DB2, Sybase, MS Access, PostgreSQL, and MySQL SQL Assistant integrates with many widely used database editors and database management and development environments including ...

    Foundations for Analytics with Python O-Reilly-2016-Clinton W. Brownley

    in Chapter 1 but aren’t used in Chapters 2, 3, and 4. It also introduces another new technique: keeping track of the previous row you processed and the row you’re currently processing, in order to ...

    php.ini-development

    directive because it is not set or is mistyped, a default value will be used. ; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one ; of the INI constants (On, Off, True, ...

    UniDAC 7.1.4

    It is important to know that UniDAC, ODAC, SDAC, MyDAC, and IBDAC use the common base packages, so product compatibility is provided for the current build only. In the other words, if you upgrade one ...

    UE(官方下载)

    How to check your JavaScript source code for common mistakes without actually running the script or opening the web page Character properties at your fingertips Access the properties of a character ...

    go系统编程(英文版)

    used for buffered input and output. You will also create Go versions of the cp(1), wc(1), and dd(1) utilities. Lastly, you will learn about sparse files, how to create sparse files in Go, how to read ...

    CakePHP 1.3 Application Development Cookbook.pdf

    line tools, which can be used to perform intensive tasks and any other type of non interactive processing. This chapter introduces the reader to CakePHP shells by starting with the process of ...

    .htaccess

    <br>To prevent against this (without creating lots of new 'index' files, you can enter a command into your .htaccess file to stop the directory list from being shown: 为避免这种情况(而不必创建...

Global site tag (gtag.js) - Google Analytics