create users table sql

sql create 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;

Posted by: Guest on October-19-2021

Source

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

CREATE TABLE Users ( UserID INT AUTO_INCREMENT PRIMARY KEY, Username VARCHAR(50) NOT NULL UNIQUE, PasswordHash VARCHAR(255) NOT NULL, Email VARCHAR(100) UNIQUE, CreatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP, UpdatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP );

Code answers related to "create users table sql"

Browse Popular Code Answers by Language

Answers for "create users table sql"

Code answers related to "create users table sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us