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';




Comments

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.

T-SQL to set Max memory in MSSQL

 To set max memory for Microsoft SQL server, use the below Transact SQL. USE master EXEC sp_configure ''show advanced options'', 1 RECONFIGURE WITH OVERRIDE GO --To set a maximum memory limit, type the following, pressing Enter after each line: USE master EXEC sp_configure ''max server memory (MB)'', <MaxServerMemory> RECONFIGURE WITH OVERRIDE GO --MaxServerMemory is the value of the physical memory in megabytes (MB) that you want to allocate. --To hide the maximum memory setting, type the following, pressing Enter after each line: USE master EXEC sp_configure ''show advanced options'', 0 RECONFIGURE WITH OVERRIDE GO exit