mysql Random password will be generated in the latest version , Stored in /etc/my.conf In the file of , But most users don't care , Because random password recognition is too poor , So we can configure the database user and set the password by ourselves .

  • Set skip password login root user
skip.grant.table
  • land

mysql -u root -p

  • Change user password

update user set password=password("1q2w3e4r") where user="root";
flush privileges;
  • Create a new user
insert into mysql.user(Host,User,Password) values("localhost","userName",password("1q2w3e4r"));
flush privileges;
  • Assign permissions
grant all privileges on databaseName.* to UserName@localhost identified by '1q2w3e4r';
flush privileges;

Complete the above process to achieve a basic user generated and configured permissions , If you need to control CURD Operation to change the relevant permissions

MySQL More about creating users and assigning user rights

  1. mysql Create new users and assign database permissions

    Here's how to Linux Create and set up a MySQL user . First of all root Log in as MySQL Server . $ mysql -u root -p When the verification prompt appears , Input MySQL Of root Password of account number ...

  2. Confluence 6 MySQL Create databases and database users

    Once you have successfully installed and configured MySQL database server , You need for your Confluence Create databases and database users : stay MySQL Run as super user in 'mysql' . The default user is 'root' Simultaneity ...

  3. oracle Create tablespace And creating users and assigning user rights

    Create a table space called ABC create tablespace "ABC"     // It seems to be capitalized datafile 'D:\oracle\TBSPACES\ABC.dbf'   / ...

  4. mysql Create table spaces and users

    Create a table space name create database Space name default character set utf8 collate utf8_bin; Create user create user user name identifi ...

  5. linux Create a new user and assign sudo jurisdiction

    A new user useradd [username] Set the password for the user passwd [username] Set up sudo jurisdiction First of all, will sudoers Permission settings are writable chmod u+w /etc/sudoers ...

  6. SAP User role assignment function permissions

    Transaction code PFCG Modify role choice [ Permission default ] choice RFC The input function can only be a function that allows remote connection , Otherwise, it cannot be called and added to the role . Finish adding .

  7. MySQL Create stored procedure / The permissions required by the function

    alter routine--- Modifying and deleting stored procedures / function create routine-- Create stored procedure / function execute-- Calling stored procedure / function Here's an introduction MySQL All the right posts http:/ ...

  8. LINUX Understanding of super users and ordinary users

    What is a super user In all Linux In the system , The system is all through UID To distinguish the level of user rights , and UID by 0 The system has agreed that the user has super permissions . The super user has the highest authority agreed by the system to operate in the whole park , So super users can complete system management ...

  9. stay Linux Next to the mysql Create users and assign permissions and problem solutions

    stay linux Lower installation mysql Please refer to the linux Installation in system mysql Server detailed steps 1. A new user // Sign in MYSQL @>mysql -u root -p @> password // Create user mysql ...

Random recommendation

  1. Cocos2dx Diaries of tangkeng : particle system PositionType The correct use of

    Cocos2dx The particle system in , There are three ways of positioning , Corresponding to different needs . Before I had an effect I wanted to do , It's a comet like sweep . But when the parent node is CCLayer When you follow an object , Found that the tail didn't follow CCLayer Move , It is ...

  2. fastreport how Set up richview Of Row height

    richview The row height change in is a bit special . Must be in AfterData Only when the event is executed can it be modified : in other words , If you simply put a button , To send a message to richView->RichEdit , And then call frxRep ...

  3. [ Game templates 19] Win32 Physical engine Move at a constant speed

    >_<:Learning the physical engine >_<:resource >_<:code #include <windows.h> ...

  4. Dell How to disable touch pad in notebook

    One · Find the folder where the touchpad driver is located ( Other models My book , Please explore for yourself , Just find out where the driver is ), commonly stay C:\program files\delltpad in ( If not, please download an loading ), Pictured : Two · double-click Del ...

  5. Self use h5 The writing wheel . Write and post it .

    <!DOCTYPE html> <html> <head lang="en"> <meta charset="UTF-8&quo ...

  6. understand Shadow DOM( One )

    1. What is? Shadow DOM? Shadow DOM According to the English translation, it can be understood as shadow DOM, What is shadow DOM Well ? It can be understood that under normal circumstances, it is invisible to the naked eye DOM structure , Well, if you can't see it normally , that ...

  7. MinGW GCC 7.1.0 2017 year 6 It's coming out in September

    MSYS_MinGW-w64_GCC_710_x86-x64_Full.7z Release date : 2017-06-03 18:33 69.4M Download address : http://xhmikosr.1f0.de/too ...

  8. Not the same go Language -error

    Preface   go Linguistic error Processing mode , In the current popular programming language, it belongs to spearhead . It seems that it was born to be used to distinguish from others .TIOBE All the top ten except C Language , There is no exception try catch Camps . Platoon go Before the language in addition to C And ...

  9. 【 Arrangement 】Java 9 New features summary

    distance Java 8 It's been more than three years since it was officially released ,Java 9 On 2017 year 9 month 21 Official release , You may have heard of Java 9 Modular system ( The most talked about ), But there are many other updates to this new version . Here I sort out Java ...

  10. [ translate ]CQRS Introduce

    The following is my understanding after reading the original . It's not a word for word translation , Will try to keep the original meaning . What is? CQRS: CQRS It means separation of command inquiry and responsibility (Command Query Responsibility Segreg ...