How To Create New Users In Mysql With PRIVILEGES
Adding New User In MySQL We can create users in MySQL in two ways: 1) By using statements intended for creating accounts, such as CREATE USER or GRANT 2) By manipulating the MySQL grant tables directly with statements such as INSERT, UPDATE, or DELETE I will show you how, can we add user using the first method, that is using MySQL grant command. First, use the mysql program to connect to the server as the MySQL root user. Here root user is representing the Main Super Admin kind of user. If we have password for this Super user root then perform the following command, First, use the mysql program to connect to the server as the MySQL root user: shell> mysql --u=root –p The system will ask you for password, then enter the password Shell>******* If you don’t have any password set for the Super User root, u can connect to the MySQL server as follows, shell> mysql --user=root Then select the mysql database (Note:: here the name of the database is it ...