creating a user in sql

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

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,           -- Unique ID for each user
    username VARCHAR(50) NOT NULL UNIQUE,        -- Username (must be unique)
    password_hash VARCHAR(255) NOT NULL,         -- Hashed password
    email VARCHAR(100) NOT NULL UNIQUE,          -- User email (must be unique)
    full_name VARCHAR(100),                      -- Full name of the user
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- Timestamp when user is created
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP -- Auto-updated timestamp
);

INSERT INTO users (username, password_hash, email, full_name)
VALUES ('john_doe', 'hashed_password', '[email protected]', 'John Doe');

SELECT * FROM users WHERE username = 'john_doe';

Posted by: Ritik Raj on November-30-2024

Source

Code answers related to "creating a user in sql"

Browse Popular Code Answers by Language

Answers for "creating a user in sql"

Code answers related to "creating a user in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us