Sunday, 15 January 2012

php - create new user for mysql database and grant only certain priveledges -


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

  1. Create a new < Li> Set user passwords
  2. Disable some options like Delete, Drop, Export and Import.
  3. < 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