Onforum.net - Web and gaming resource community

Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members .

Tutorial How to create new mysql user

Vanilla

Elite
Elite
Credits
1,180
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.
 
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.
 
Thread starter Similar threads Forum Replies Date
Tutorials 1
Blaze Tutorials 2
[RaffaeL] Tutorials 2

Similar threads


Top

Dear User!

We found that you are blocking the display of ads on our site.

Please add it to the exception list or disable AdBlock.

The advertises that you'll see aren't intrusive they just help us to keep the community alive

If you don't want to see those ads just buy an upgrade.

Thank you for understanding!

Baba2

Baba2 Purchase

User upgrade! at

🔥 Upgrade Now

Escanor25 Purchase

User upgrade! at

🔥 Upgrade Now
Tigrex

Tigrex Purchase

User upgrade! at

🔥 Upgrade Now