sql user

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; # Some PHP versions may have issues with the above statement # use the older mysql_native_password plugin instead: CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; # Give access to all databases with all privileges like root user GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION; # Give access to SPECIFIC database with all privileges GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost'; # when done, flush privileges. FLUSH PRIVILEGES;

-- Creates the login AbolrousHazem with password '340$Uuxwp7Mcxo7Khy'. CREATE LOGIN username WITH PASSWORD = 'password'; GO -- Creates a database user for the login created above. CREATE USER AbolrousHazem FOR LOGIN AbolrousHazem; GO

sql user

-- Creating a user with a password (using native password plugin)
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

-- If there are compatibility issues with some PHP versions, use the mysql_native_password plugin
CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

-- Grant all privileges on all databases (similar to root access)
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;

-- Alternatively, grant all privileges only on a specific database
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

-- Apply the changes made to privileges
FLUSH PRIVILEGES;

Posted by: Ritik Raj on December-02-2024

Source

Code answers related to "sql user"

Browse Popular Code Answers by Language

Answers for "sql user"

Code answers related to "sql user"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us