'Username’ - you need to enter the username
Posted: Sat Apr 05, 2025 5:37 am
Create user – This command is responsible for creating a user.
'username’ – Here you specify the username in quotes
'Host’ – Here in quotes you specify the connection method, if you specify localhost, then you cannot connect remotely, in my example I created a remote connection
Identified by - Authentication method
'password’ – here in quotes you need to specify a password that fits your system, which we specified earlier. (Number 2, remember?)
very important do not forget to put at the end ;
Now that the user has been c level executive list created, he needs to be given some rights, to do this, enter the command:
GRANT ALL PRIVILEGES ON database name. * TO ‘username’@’host’
priveleg
Database_name. - you need to enter the database name
don't forget to put a period at the end of the name
'host’ - indicate whether it will be possible to connect remotely
As you can see, I gave all the permissions to work with this database to the user I just created.
'username’ – Here you specify the username in quotes
'Host’ – Here in quotes you specify the connection method, if you specify localhost, then you cannot connect remotely, in my example I created a remote connection
Identified by - Authentication method
'password’ – here in quotes you need to specify a password that fits your system, which we specified earlier. (Number 2, remember?)
very important do not forget to put at the end ;
Now that the user has been c level executive list created, he needs to be given some rights, to do this, enter the command:
GRANT ALL PRIVILEGES ON database name. * TO ‘username’@’host’
priveleg
Database_name. - you need to enter the database name
don't forget to put a period at the end of the name
'host’ - indicate whether it will be possible to connect remotely
As you can see, I gave all the permissions to work with this database to the user I just created.