Welcome Guest ( Log In | Register)



 
 Reply to this topicStart new topic
> Adding Users To Databases Using Phpmyadmin
Amezis
post Dec 31 2005, 01:08 PM
Post #1


Privileged Member
*********

Group: Members
Posts: 535
Joined: 14-February 05
From: Oslo, Norway
Member No.: 3,759
I am running my own apache server with PHP and MySQL, with phpMyAdmin on my own computer, to test things locally. I know how to create databases and how to create users, but how can I add a user to a database?

(list)

Go to the top of the page
 
+Quote Post
leiaah
post Jan 1 2006, 05:31 PM
Post #2


Super Member
*********

Group: Members
Posts: 436
Joined: 21-January 05
From: Koronadal City, Philippines
Member No.: 3,358
MySQL has a default database called mysql which contains the table user where users with different access privileges are stored. To add users in the user table with privileges, login to mysql using your root account and type the following:

CODE
GRANT privileges  
ON databasename.tablename
TO username
Identified by 'password';

example:

GRANT SELECT, INSERT     [I]//or GRANT ALL to grant all privileges[/I]
ON DB1.*
TO AMEZIS
IDENTIFIED BY 'PIZZA';

I hope this helped. smile.gif

(list)

Go to the top of the page
 
+Quote Post
ernad
post Jan 2 2006, 09:58 PM
Post #3


Newbie [Level 2]
**

Group: Members
Posts: 26
Joined: 2-January 06
Member No.: 16,526
and i will explain you:
1st: On index page of phpmyadmin find link: Privileges
2st: On page Privileges you have user list click on edit user privileges.
3th: On page find Database-specific privileges select from list database and press go that is all...

(list)

Go to the top of the page
 
+Quote Post
« Next Oldest · PHP Programming · Next Newest »
 

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Script: Phpbb Mod, Total Users Registered(1)
  2. Users Online Script In Php(7)
  3. Sum(11)
  4. Editing Footer.php(2)
  5. Can Reset The Id Auto Increment?(10)
  6. Login / Authetication System Using Database(4)
  7. Adding One Day To Date(3)
  8. Show Users Logged In(5)
  9. Help Installing Phpmyadmin ..(2)
  10. Script That Tracks The User Status(4)
  11. Phpmyadmin And Php And Mysql(0)
  12. Error Importing Sql Query Via Php(6)
  13. Php Codes: Adding Clothing, Ion Laser Guns And Shooting Projectile Cannons(3)
  14. Help With Some Website Coding(4)
  15. Add Users On Email Program With Php?(1)
  1. Phpmyadmin Login Problem!(1)
  2. Adding String To Integer?(1)
  3. Php Ftp Upload Form(0)
  4. How To Print In Php(9)


 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 21st August 2008 - 01:39 AM
Powered By IP.Board © 2008  IPS, Inc.
Licensed to: Xisto Corporation