|
|
|
|
![]() ![]() |
Sep 21 2004, 10:07 PM
Post
#1
|
|
|
Newbie [Level 1] ![]() Group: Members Posts: 17 Joined: 16-September 04 Member No.: 1,132 |
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. |
|
|
|
Sep 21 2004, 11:16 PM
Post
#2
|
|
|
the one with a short temper ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 247 Joined: 26-July 04 Member No.: 211 |
are you willing to make a user on a db set up on your pc or at trap?
|
|
|
|
Sep 22 2004, 09:32 AM
Post
#3
|
|
|
Core2Q-QX6800 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: [HOSTED] Posts: 1,093 Joined: 3-August 04 From: Nigeria Member No.: 569 |
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.
|
|
|
|
Sep 24 2004, 12:24 AM
Post
#4
|
|
|
Advanced Member ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 113 Joined: 23-September 04 Member No.: 1,240 |
you neeed to create a db anduser and pass for ur program u can do that in the cpannel..
|
|
|
|
Oct 1 2004, 05:51 AM
Post
#5
|
|
|
Member [Level 1] ![]() ![]() ![]() ![]() Group: Members Posts: 51 Joined: 24-September 04 Member No.: 1,256 |
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://dev.mysql.com/doc/mysql/en/Adding_users.html |
|
|
|
Oct 8 2004, 07:09 PM
Post
#6
|
|
|
Newbie ![]() Group: Members Posts: 9 Joined: 8-October 04 Member No.: 1,524 |
i simply use phpmyadmin to do that
Remember to reload the server because the change Bye |
|
|
|
Oct 10 2004, 07:54 PM
Post
#7
|
|
|
Newbie [Level 1] ![]() Group: Members Posts: 12 Joined: 10-October 04 Member No.: 1,650 |
For create new user and pass with mysql console you have to
1)enter to this console as root (for example) >mysql -u root -p 2) 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 |
|
|
|
![]() ![]() |
Similar Topics
|
Lo-Fi Version | Time is now: 22nd November 2008 - 03:53 PM |