Skip to main content

Create users in MySQL

Create users

The following steps are explained to you how create the users in MySQL.
  1. This query is used to create a user in the particular host only,
     create user 'username'@'hostname' identified by 'password'; This user cannot access from the other hosts
  2. If you want to the user access from other machines then use the below query,
    create user 'username'@'%';
  3. The below query is used to give the all privileges to the user on the particular database,
    grant all privileges on '<database>.<tables>' to 'username'@'hostname';
  4. The below query is used to give some privileges to users on the particular database,
    grant select,update on '<database>.<tables>' to 'username'@'hostname';




Labels:

Comments

Post a Comment

Popular posts from this blog

Identify the duplicates in MySQL

To identify the duplicate entries in MySQL, use below query.                      SELECT COUNT(*) as repetitions, group_concat(id, ' (', startTime, ', ', endTime, ') ' SEPARATOR ' | ') as row_data FROM GROUP BY startTime, endTime HAVING repetitions > 1 FYI, id, startTime and endTime columns should be changed based on your table schema. you can change the output format here like alias and the separator.
Post a Comment
Read more

Exclude or Include table(s) during creating backup from MySQL

 To exclude tables when you are creating database backup from MySQL, execute below query. mysqldump -u root -p<Password> DATABASENAME --ignore-table= DATABASENAME.TABLENAME  > BACKUPFILENAME.sql  To include  tables when you are creating database backup from MySQL, execute below query. mysqldump -u root -p<Password> DATABASENAME TABLENAME1 TABLENAME2  > BACKUPFILENAME.sql Take note that there is no whitespace between -p and the password..
Post a Comment
Read more