Welcome Guest ( Log In | Register)



 
Reply to this topicStart new topic
> Mysql Question:
XtremeGamer99
post 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.
Go to the top of the page
 
+Quote Post
BoSZ
post 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?
Go to the top of the page
 
+Quote Post
odomike
post 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.
Go to the top of the page
 
+Quote Post
akz
post 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..
Go to the top of the page
 
+Quote Post
sanweikui
post 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
Go to the top of the page
 
+Quote Post
virrey
post 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
Go to the top of the page
 
+Quote Post
moscower
post 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
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Mysql Downtimes...(39)
  2. Mysql Database Setup : Setting Up Mysql Database(6)
  3. Complete Login System(57)
  4. Increment A Mysql Column(7)
  5. Import From Excel File Into Mysql Database(11)
  6. Linking To Mysql From Vb(7)
  7. Mysql Database Size(7)
  8. Help Moving Mysql Files To A New Host(2)
  9. Can You Add Images Into A Mysql Database?(21)
  10. Subquery In Mysql(5)
  11. Quick Question(10)
  12. Qupis : Free Hosting With Php, Mysql, Cpanel. (one Line Text Ad At Bottom)(41)
  13. Mysql Won't Update(5)
  14. Mysql, Php, Apache Downloads And Setup Was A Nightmare(10)
  15. It Went Well For A While(5)
  1. Mysql Db Is Down Getting Following Error(2)
  2. Need Advice On Setting Up Mysql Database.(4)
  3. The Only Reason I Choose Ms Sql Server Rather Than Mysql(0)
  4. Mysql Database Not Working(3)
  5. Creating A Php Login System Using Mysql(10)
  6. Mysql Hacks(6)
  7. Vb And Mysql(3)
  8. Mysql Server Down(10)
  9. Mccodes With Mysql! [resolved](6)
  10. Website Structure(3)
  11. Php Myadmin(6)
  12. How To Connect Mysql With Jsp ?(4)
  13. Beginning Php And Mysql: From Novice To Professional, Third Edition Review(1)


 



- Lo-Fi Version Time is now: 22nd November 2008 - 03:53 PM