I want to create a new mysql user, in which some options are used in mysql database.
Make this my current user query:
Identify 'password' by user 'new user' @ 'localhost'; When I am running this code, the server displays the following error message:
(Error: 1227 SQLSTATE: 42000 (ER_SPECIFIC_ACCESS_DENIED_ERROR) Message: Login Disclaimer; Using MySQL version 5.0.
Please help me
- Create a new < Li> Set user passwords
- Disable some options like Delete, Drop, Export and Import.
-
< Div class = "post-text" itemprop = "text">
There are three steps
database Create new rights with all new commands this way create database DBTEST IT is fully run with any error, then creating new user 'NEWUSERPASSWORD' was identified 'democracy' @ Create user for 'LOCUSHOST' After creating user give authorization to create table ROP tab ..... * Approve all privateers * * 'News And 'A' command Flush Pvt You can also give rights on such a specific database
Allow all authorities on DBTEST. * 'Newsier' @ 'Localhost'
No comments:
Post a Comment