Jump to content
xisto Community
XtremeGamer99

Mysql Question:

Recommended Posts

what do I need to input to create a new user and pass.I've tried before, but it kept giving me an error like I wasn't allows to creat users. Please note that this is on my computer. So, I was also wondering how to 'log in' to root user so that i can make a new user. Thanks in advance.

Share this post


Link to post
Share on other sites

why dont you try installing from your site's cpanel? that wil be much easier and faster for you. it will be easier for you to configure too.

Share this post


Link to post
Share on other sites

For create new user and pass with mysql console you have to 1)enter to this console as root (for example)>mysql -u root -p2) type command for using mysql system database:>use mysql;3) add user to the user database:>INSERT INTO user (Host, User, Password) VALUES ('localhost', 'username', PASSWORD('userpassword'));It's all

Share this post


Link to post
Share on other sites

Just use cpanelGo to the database sub menu on the main CPanel screen.click on MySQL databasesyou should now see a page that lists all of your MySQL databases and users.Just scroll down, and you should see a create user area, just create a user then, and scroll down a bit furuther, and select a database in on list, and the user you just created to add it to the database so it can connect!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.