Amezis
Dec 31 2005, 01:08 PM
| | 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? |
Reply
leiaah
Jan 1 2006, 05:31 PM
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. 
Reply
ernad
Jan 2 2006, 09:58 PM
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...
Reply
Recent Queries:--
mysql create user phpmyadmin - 0.86 hr back.
-
phpmyadmin create db user - 2.85 hr back.
-
phpmyadmin add user - 4.46 hr back.
-
how to create users mysql using phpmyadmin - 5.10 hr back.
-
phpmyadmin add user to database - 10.04 hr back.
-
create user in database phpmyadmin - 17.54 hr back.
-
add user phpmyadmin - 32.57 hr back.
Similar Topics
Keywords : adding, users, databases, phpmyadmin
- Php Ftp Upload Form
Adding User Directory to PHP Upload Form - Help (0)
Adding String To Integer?
(1) Create a PHP program with the following requirements Create a program that does the following:
creates a variable called “test” (remember the dollar sign) stores the number 35 to
test and prints the result adds 10.0000 to test and prints the result subtracts 5.123123 from
test and prints it out stores the character string “happy to be here” to test and
prints adds 10.0000 to the variable test (try to guess what will happen) whats the solution to
this problem? any help would be appreciated.....
Phpmyadmin Login Problem!
(1) I have easyphp. But i can not log when i go to phpmyadmin. I directly enter the page. But i think i
should normally have to log in before enter that page. What should i do to configure the access to
phpmyadmin? Thank for help....
Add Users On Email Program With Php?
(1) First of all Marry Christmas, Well so i am in some kind of a problem, i can't find out how to
add users to my mail service, i have no idea what SMTP/IMAP program the server runs, neither does
the system administrator. But it should be kinda the same thing for all of them if i am not wrong,
Anyways i have full access to server so i can do whatever i want to do, i have SSH access too (Root
access /rolleyes.gif" style="vertical-align:middle" emoid=":rolleyes:" border="0"
alt="rolleyes.gif" /> )....
Help With Some Website Coding
Databases and saving form results (4) Hey all, I was looking for some help with creating my new website. I have a form already created,
with some text areas, checkboxes, drop down menu's, ect. I need some help setting up the code to
save the form data once the user clicks "Submit" after filling in their information in the form. I
was hoping to do this 2 ways - 1. Saving the information into some type of database (MySQL I'm
guessing?) and 2. Have the form results emailed to me. I am familiar with the old way of emailing
the results by putting "mailto:email@domain.com" into the form, but new browse....
Php Codes: Adding Clothing, Ion Laser Guns And Shooting Projectile Cannons
(3) Ok here is a set of codes that is on another forum website. It is really neat becuase you can have
cursors and other objects on your webpage that can shot projectiles. Also you can add some other
cool graphics. Go to the link below. php coding ....
Error Importing Sql Query Via Php
Works in PHPmyAdmin (6) CODE function sql() { $fp =
fopen("sql.sql","r"); $sql =
fread($fp,filesize("sql.sql")); fclose($fp);
return $sql; } Thats $this->sql and here is the other source CODE
function insert_sql() { if($_GET['insert']) {
$template = new template; $db = new db;
$db->connect(); $query = $this->sql(); ....
Phpmyadmin And Php And Mysql
tutorial (0) hi i think phpmyadmin is nice script (3rdparti) to learn php and mysql , you can add database and
then make tabel with rows and columns then you can customise (search , show rows , show columns ,
add rows , delete rows) tabel in phpmyadmin when you are customise phpmyadmin , this script show you
php code . you can use this code for browse in database . for example : showing tabel : CODE
SELECT * FROM `tabelname` LIMIT 0 , 30 searching : CODE SELECT `columns`
FROM `tabel` LIMIT 0 , 30 you can use with while loop showing Ascending....
Script That Tracks The User Status
how can I track on or offline users? (4) long explaination: hey, I'm building a user profile site right now. And, I kinda know how to
make a online/offline detector, but not totally sure. I know I can make a mysql database to track
them, but how does it entrer the information? I could easily put in a field where when they login it
sets them to online, but if they don't sign out, and just exit the browser, how can I tell.
short: I want someone to tell me how to make a online/offline status detector, like they have here
on trap17. I'd be thrilled if you can post to this, thanks, arcticsnpr....
Help Installing Phpmyadmin ..
(2) i've installed php and mysql to my computer and i want to install PhpMyAdmin , (i have apache) ,
i tried to find how to confure it , and it says Create the file config.inc.php in the main
(top-level) directory , i dont know how to create that file..can some one tell me how i can confure
that config file ?? and how i can run php in safe mode ?....
Show Users Logged In
Some help needed.. (5) I need some help if somebody can help me out please doit /smile.gif" style="vertical-align:middle"
emoid=":)" border="0" alt="smile.gif" />.. Ok here is the thing - I have an login box (works
perfect) and I have MySQL database (works perfect).. Now I need to make thing like a list where
shows everyone who is logged on.. But making it I need to use the same MySQl database and the same
login box.. Example: when your write tour Login and password and press "Log-in!" opens page
where is list of all logged in member.. If there is ant tutorial aor scripts/codes please....
Adding One Day To Date
i'd like to add one day to date (3) I would like to add one day to date.Doesn't any one have a simple code that I can have. or mabe
a link. date("Y-m-d H:i:s") + (1800 * 24);//this doesnt work ;/ but i need to have 24 hours after
date for a check. Thanks for taking the time i hope some one can help me out. Dont warry about it
if you dont have some thing already made. ....
Login / Authetication System Using Database
adding information (4) Is there any way to make such database where I can write like name and passwords.. Then make an
login box, and when somebody trys to acces the login he needs to write the name and password.. Then
it is verifyed if is there such name and password and if it is then acces the page.. I think there
is posible something like that with MySQL (db).. but can anybody say me a script or way to make
something like that? Alredy thanks......
Can Reset The Id Auto Increment?
phpMyadmin (10) hi, Can we reset the id auto increment in the mysql database using by phpMyadmin? let's say the
shoutbox . the id #number table.. somehow i deleted some rows.. and i wanted to re-order/reset the
id number acendingly in order rather than skip out.. thks ....
Editing Footer.php
adding a script (2) hey can somebody put this script into my footer.php file? because i don't know how. the script
has to go between the and ok this is the script... CODE <!-- Clicksor.com Advertising
Code Begin --> <script type='text/javascript'> <!--
clicksor_layer_border_color = '#B4D0DC'; clicksor_layer_ad_bg = '#ECF8FF';
clicksor_layer_ad_link_color = '#0000CC'; clicksor_layer_ad_text_color = '#000000';
clicksor_text_link_bg = ''; clicksor_text_link_color = '#000FFF';
clicksor_enable_pop = fa....
Sum
Adding things (11) I have this tiny problem, that is I have a whole list of vairables, 25 infact, and I'm trying to
add them, and store this result in another variable. The problem when I try to call that variable
the resulting page justs leaves a blank spot, and the IF array that I have won't change, it just
goes for the first choice. Is this wrong? CODE
$var1+$var2+..........$var24+$var25 = $vartotal; bearing in mind that
there is more in the middle I just didn't feel like typing it!....
Users Online Script In Php
how do i get one? (7) I've been seeing a whole bunch of sites that have a Statistics corner, and in there, there are
things that says "Users Online:", "Page Loads:", "Unique Hits:", and "IP:". Well, I was wondering,
where do these users get one of these nifty things? I know that PHPNuke offers one, but most of the
sites that I go to do not use PHPNuke. Any reply is appreciated. /smile.gif' border='0'
style='vertical-align:middle' alt='smile.gif' /> ....
Script: Phpbb Mod, Total Users Registered
Display the total users anywhere on your site. (1) This is for phpBB V2+ It displays the total number of registered users anywhere you want. This file
is called: phpbb-totalusers.php CODE <?php /** * ©2005 Craig lloyd. All rights reserved. * *
Mod Title: Total Registered Users * Author: Craig Lloyd * Description: Shows
total number of registered users * Release: v1.2, 10th May 2005 *** * Demo:
http://www.toxicsims.co.uk/ (stats box) * Installation Level: Easy *
Installation Time: 1 minute * Files To Edit: This one * Included Files....
Php Sessions
Multiple users using the same login (2) Hi, I'm realtively new to PHP and I'm considering creating some login functionality.
However I want a group of users to use the same loginname and password. They will be loggin infrom
different machines. The users will know they are sharing the account. Can anyone give me an idea
of what kind of effect this might have on my sessions? Will it create any odd hiccups or other
strange things?....
Help With Adding Music/video
help (4) Hey, i really need help. How do i add video/ Music to php. If you know please post here nad help
me. I would really appritiate it. ok thanks.....
Looking for adding, users, databases, phpmyadmin
|
|
Searching Video's for adding, users, databases, phpmyadmin
|
advertisement
|
|
Jul 6, 2008
