Tutorial How to create new mysql user

Vanilla · Jun 28, 2021

First reset mysql password.

Code:

/usr/local/etc/rc.d/mysql-server stop

Code:

mysqld_safe --skip-grant-tables &

Code:

mysql -u root

Code:

use mysql;

Code:

update user set password=PASSWORD("PAROLA_NOUA_PENTRU_USER_ROOT") where User='root';

Code:

flush privileges;

Code:

quit

Code:

/usr/local/etc/rc.d/mysql-server restart

Now that we have changed the root user password we can create a new user. Also in putty we write the following

Code:

mysql -u root -p

We will be prompted to enter a password, enter the password set in step 5 above.

Code:

use mysql;

Code:

CREATE USER 'USER_NOU'@'%' IDENTIFIED BY 'PAROLA_USER_NOU';

Code:

GRANT ALL PRIVILEGES ON * . * TO 'USER_PUS_LA_PASUL_4'@'%';

Code:

quit

And that was all, now you can log in to navicat.

arist · Jun 30, 2021

Thanks, you should note this is only for FREEBSD. (Will not work on Ubuntu/Centos etc.)
Because some have webserver on ubuntu or centos not freebsd.

Welcome!