Mysql Question:

[XtremeGamer99 0]

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.

[BoSZ 0]

are you willing to make a user on a db set up on your pc or at trap?

[odomike 0]

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.

[akz 0]

you neeed to create a db anduser and pass for ur program u can do that in the cpannel..

[sanweikui 0]

after you install the mysql, there is a root user you can use.
to create any other user and password,you should use "grant" or "insert".
the link under will give you help:
http://forums.xisto.com/no_longer_exists/

[virrey 0]

i simply use phpmyadmin to do thatRemember to reload the serverbecause the changeBye

[moscower 0]

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

[minimcmonkey 0]

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!