Re: web hosting/PHP MyAdmin
Matt, Hey. I use www.powweb.com they have a plan for $7.77 a month, 650MB storage, blah blah blah give them a look... The important thing is that they have PHP and I believe command line access, you'll have to use a MySQL client to connect (seperate MySQL server). I hate to sound like I'm promoting but if you decide to go with them, they have a referal program and they'll give me a month free when I re-up, if you could tell them that I sent you my site is www.mapleave.net I would appreciate it! HTH, Ryan --- Matthew K. Gold [EMAIL PROTECTED] wrote: Hi, I need to move my site to a host that supports PHP and MySQL. I found a nice deal that provides a lot of good stuff for an affordable price (sitelutions.com is offering 5 MySQL databases, PHP support, cgi, etc etc for $9.95/month). There's only one problem--they don't allow you to edit the MySQL databases through a shell--you have to use a web-based control panel and phpMyAdmin. My problem is that I'm used to editing my MySQL databases through the shell, and I find the phpMyAdmin admin kind of confusing. I have two questions: 1. Was anyone out there in my position before, but then once you tried phpMyAdmin, you found that you liked it a lot? 2. Does anyone know of any better, or equal deals out there that also allow shell access? Thanks very much in advance for your help. best, Matthew Gold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Pull updated Records without a date field?
--- Paul DuBois [EMAIL PROTECTED] wrote: At 11:38 -0500 7/10/03, Keith Hamilton wrote: Hello, Is there a way to pull all updated records without having a date field in each record? -- Keith Can't you just do: select field from table where datefield somedate; That way the date field won't be displayed in the output. I think that will work, Ryan __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: backup / superuser only
I wonder if you could make a backup of your original users table, then make one of JUST your super user... Then when you go to do your back up you would copy your table with JUST your super user in there and go to work... After you are done with the backup copy your old table back and restart mysql or flush the privilages. Not sure if that will even work but it might work for a temp fix. Ryan --- Rudy Metzger [EMAIL PROTECTED] wrote: Dear all, Is there a way to start mysqld in a way, that say only a superuser can connect. I would need this e.g. for restoring a backup, because I do not want users to connect to the server while I restore the binary log. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Group by and Count query
snip Here is the query I'd like to run (which fails - but is exactly what I need for a query): select sum(count(host)) from TABLE_HOST where path_a='' group by host /snip well I think this one fails because count only ever returns one number (correct?). So I would think sum would take in a stream of numbers and then add them all together. Thus sum would fail, in my mind anyway. __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Join problem
Short answer is mysql does not do sub-selects (i.e., a select inside of a select). The join part is not this issue. Wouldn't this depend on the version... I thought the newest versions, 4.x+, supported sub-selects. Ryan __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Don't show a record based on a condition?
Hey all, I can't seem to wrap my head around this, please see if you can help me out. I have 2 tables. One with some basic info but they are structured as follows. info table: IDNum(PK) LName FName Title Deladd City State Zip codes table: IDNum (used only so that there could be a primary key :-/ ) info_IDNum(fk) code The code column in the codes table can contain multiple codes for each info_IDNum. I want to make a query where it shows all the info_IDNum results that DON'T have an entry in the codes.code = 13. Where I am having trouble is that there are multiple codes for any given IDNum. Please help, thanx Ryan __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query Help
--- Andrew [EMAIL PROTECTED] wrote: Hi All MySQL guru's I have a query that I need some help with. I have put into operation a setup that needs to be chnaged and could do with a little help before the Db get any bigger. It's only a small MySQL DB at the moment but will grow so I need to get this right now before it gets bigger. Andrew Well you're gonna need to describe things a little better. Saying you need help with a query with out posting it or the table descriptions isn't going to do anyone any good. Ryan __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Get warning info from mysql_info()
But I have no idea what the warning is. Is there any way to find out? mysql_error returns '\0' so it's no help. Thanks! Do you have access to your mysql logs? If you do I'm thinking that the warning should be in there. When I just looked at my logs I only see one specific mysql log named mysqld.log, so maybe its in there. HTH, Ryan __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Simple SELECT question
--- [EMAIL PROTECTED] wrote: I need a little help querying 2 tables in MySQL; Table User User_Id // Id = 2 User_Name // John Table History User_Id // 2 User_History // John has born in 58 SELECT User_History FROM History WHERE User_Id = 2; // return John has born in 58 But what my SELECT should look if i don't know the user id and want search the User_History by the User_Name? SELECT User_History FROM History WHERE User_Id = ( SOMEWAY TO DATABASE FIND JOHN ID BY JOHN NAME ) I am no MySQL expert by any means, but I believe that a sub select would handle it. However, last I knew MySQL didn't support them. So I believe the other solution would be to do a JOIN, I thought I remembered people here saying that JOINs are the sub-select work around. Seeing as how I do not know them at all I can't offer an example... Sorry If this is incorrect someone please correct me. Thanx, Ryan __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can't find /tmp/mysql.sock
when I do this this is what I get: starting mysql with databases from /var/lib/mysql 030228 16:00:55 mysqld ended This may be your culprit right here... not sure where the mysql_install_db defaults its installs to, but I'm guessing its not /var/lib/mysql. And you installed everything into /usr/local/mysql, so you may need to edit your config file to tell it where to look for the install. Also when I do the following: shell ./mysqladmin ping I get the error message: ./mysqladmin: connect to server at 'localhost' failed error: 'can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! This is happening because mysqld is not running... I believe that when you run safe_mysqld it creates the /tmp/mysql.sock file. So if it never runs no file is ever made. People please correct me if I'm wrong... I've never done a binary install. I've only installed MySQL at the time of my RH8.0 install. HTH HIR(hope i'm right), Ryan __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: except?
(select Computer.CompID, Computer.Location, Computer.User from Computer where Computer.OS like Microsoft*) except all (select Software.CompID from Software where Software.Name = Excel); I think your trying to do what mySQL considers a sub-select and mySQL can't handle those yet(AFAIK). There are ways to get around doing sub-selects but I don't what they are. Please someone correct me if I'm wrong HTH, Ryan __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A mysql php question
Hello everyone,
I'm not sure if this is the proper place to be asking this question as I
believe it is more of a question on how to traverse through php arrays and such
but it is using a mysql_query function. So if this not the place pleace don't
read any further and ignore and/or delete this message.
So I am new to mysql AND php, with a background in Oracle SQL. Anyway I am just
starting out writing a web application for a DB of the collection of videos,
games, and cds of me and my wife's. So I want to start out with just making a
table with the field names as the header rows and then the data underneath the
corresponding field name/column. The current code (last part of this message)
only prints out the right column headers/field names and then puts the right
information under it but it only gives me the first record, I want all records.
*example of current code output*
IdNum FName LName
1 Ryan McDougall
This is my code so far, be prepared to laugh as this is pretty bad code I'm
sure (I just don't want to be held liable for any injuries from falling out of
your chairs :-P ):
html
headtitleMy PHP test file/title/head
body
?php
$link = mysql_connect (localhost, username, password)
or die (Could not connect br\n);
print (Connected successfullybr\n);
mysql_select_db(DBname) or die(Could not select database);
$query = SELECT * FROM Who;
$result = mysql_query ($query)
or die (Query failed);
$line = mysql_fetch_array($result, MYSQL_ASSOC);
print table\n;
print \ttr\n;
foreach ($line as $key = $value) {
print \t\ttd$key/td\n;
}
print \t/tr\n;
print \ttr\n;
foreach ($line as $col_value) {
print \t\ttd$col_value/td\n;
}
print \t/tr\n;
print /table\n;
mysql_free_result ($result);
mysql_close ($link);
?
/body
/html
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL PHP
hello all, I'm posting on 2 lists because I'm not sure were the problem is, so I'm hoping that some one can help me out. I'm running a stock RH8 machine running amongst other things MySQL 3.23.52-3, Apache 2.0, PHP 4.2.2-8.0.5 When I try a simple php script that is this (sensitive information changed to protect me): html headtitleMy PHP test file/title/head body ?php $link = mysql_connect (localhost, user, password) or die (Could not connect); print (Connected successfully); $query = SELECT * FROM who; $result = mysql_db_query (mcdougrsMedia, $query) or die (Query failed); ? /body /html The page produces the following output: Fatal error: Call to undefined function: mysql_connect() in /home/username/public_html/testing.php on line 5 Can you guys see what is wrong... or if there is other information that is needed that isn't there please let me know and I will post whatever information is needed to fix it. TIA, Ryan __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL PHP
Hey everyone, Thank you all for your quick responses and the problem was that I did not have mysql support installed for php... installed the required rpm and did a httpd restart and it wrks now!! Thanx again, Ryan __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: let users create as much DB as they want ?
--- Amer Neely [EMAIL PROTECTED] wrote: Greetings all. Hope someone could give me some pointers on this. I am working at a small ISP in Montreal. Some of our corpo users. have access to a MySQL database, that we created for them (usually, this DB is named after there username). The way we configured our mysql installation, which seams a pretty standard procedure, they can create as many tables as they want in there DB, but of course, they can't another DB. Well, we would like to do just that. Is there a way to configure mysql so that the user can create as much DB as he wants, by making sure every DB created by this user can only be accessed by him, some kind of 'root' access if you follow my logic. Furthermore, since we are billing our clients for the disk space they are using, will the structure of this will ressemble to this ; MAIN_USER - DB1 - table1, table2, ... - DB2 - table1, table2, ... Thanks for any help. I asked the same question a little while ago and the answer given to me was this: mysql GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON `user%`.* TO 'user'@'%' IDENTIFIED BY password; Of course you GRANT the user whatever privs you wantt hem to have, I think the only one they NEED to have is CREATE and then user will get to create any DB as long as it starts with their username, like userDB2. And please if anyone sees that I have messed up any thing in this please correct me. HTH, Ryan __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: relations between tables
--- Adolfo Bello [EMAIL PROTECTED] wrote: As far as I know and how I understand it, the relationships are basically all in your head... You just have to coordinate it in your queries and other functions This is not true. Fot type innodb tables, you can define REFERENCES using ON DELETE (CASCADE|RESTRICT) and/or ON UPDATE CASCADE Adolfo Awesome... Thanx for the correction as I had no idea, apparently, that this was possible!!! __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: relations between tables
--- Octavian Rasnita [EMAIL PROTECTED] wrote: Hi all, Is MySQL able (like MS Access) to define permanent relations between tables? For example, I want to define a master - child relation between 2 tables so when deleting some entries from the master table to automaticly delete the entries from the details table without specifying this in the query. Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] As far as I know and how I understand it, the relationships are basically all in your head... You just have to coordinate it in your queries and other functions __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: running mysql (mysql users)
TR, Ok first I would like to say that I have just recently started using MySQL so I feel your pain and I hope my explination helps you out. The mysql user your referring to is probably the user that is should be used to run the mysql daemon. Which would b e a seperate *nix/Windows(?) user, I'm not sure how the windows version works with users. The MySQL root user is just a built in user that is used for, generally, administrative stuff... i.e. making users, backing up DBs, etc ,etc. The built in root user has all of the priviledges it already need but in short it has ALL of the priviledges. Making yourself a mysql superuser is neither a good thing or a bad thing... It sounds to me like you are a home user just messing around with MySQL (like myself) that is why it isn't a good thing nor a bad thing. But as a general rule it you have control over the root user and you make a normal user I would say that it doesn't need to be a super user. A nice set of priviledges, I think, for a normal user... which give them creative freedom is the folowing grant statement run as the mysql root user after you do # mysql -u root -p: GRANT SELECT,ALTER,DROP,CREATE,INSERT,DELETE,INDEX,UPDATE ON `username%`.* TO 'username'@'%' IDENTIFIED BY password; Ok the `username%`.* is what give the user creative freedom... It allows the user with the username to create whatever DBs it needs BUT the DB needs to have the prefix username on the front of it. Those are back ticks not sigle quotes too by the way. This grant statement also allows the user to connect from ANYWHERE so if you want to restrict where that user logs in from apply the appropriate end to the TO 'username'@ portion... and those are single quotes. Just replace every instance of username with whatever user you are setting up. Hope that helps and sorry if it was too elementary, I had a REAL hard time getting this and this was the way I finally got it. L8R, Ryan --- [EMAIL PROTECTED] wrote: I wish to attempt to clarify one of my earlier questions: Most things I've read say to establish a mysql user -I take it this is to run the daemon(mysqld?) under? Is the above user one that will be created in the users table of the mysql db? What mysql privileges does such a user need? Also, why is a mysql root user needed and what mysql privileges does that user need? I do not know how this fits in with the above users (root mysql) but I usually make myself a mysql superuser, should I do that? Thanks, TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL user privilages
Alright I have tried to do the grant like the following: GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; With no luck I keep getting an error message... ERRO 1064: You have an error in you SQL syntax near 'usre%.* To user@% IDENTIFIED BY password at line 2 Any help would be appreciated. TIA, Ryan --- Paul DuBois [EMAIL PROTECTED] wrote: At 9:25 -0800 12/8/02, Ryan McDougall wrote: Hi thanx for the details... Ok I know I am thick... and for some reason I cannot get my head around this, let me try to explain what I want to do then maybe you can tell me its possible and how it is possible. I want to create a user that can be creative as he wants... allow him to create ANY databases he wants and delete them if he no longer needs them, but at that same time not be able to mess with ANY other privileges or anyone elses DBs. That's not how it works. You can grant privileges for any database, but you can't grant privileges for any database except certain databases. One thing that may help is that you can use a pattern to specify the database name in the GRANT statement. Then the user can create any database that has a name matching the pattern. For example, GRANT ALL ON xyz%.* ... will allow the user to create and mess with any database having a name that begins with xyz. The only other way I can think of it to compare it to a windows situation. Lets say I'm in Windows and I start up MS Access... Now with me being a Windows user I can create any DB I want and do whatever I want to the DBs I've created (as long as its not in a read only folder) but I can't see or do anything to to the other peoples creations becuase I don't have permissions to do so. Am I going to have to, as root or another super user, create his DBs for him and then give him privileges to them? I just don't get how that sort of situation works in a production environment. But then again in a production environment you don't usually have people just creating DBs at will. Again sorry for my complete lack of understanding on this and stupidity, but my brain just will not wrap itself around this issue. You're probably trying to understand the MySQL privilege system as analogous to some other type of privilege system. Try to understand it as itself and you'll probably get farther. Thanx for all the help so far, Ryan McDougall __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL user privilages
Hi thanx for the details... Ok I know I am thick... and for some reason I cannot get my head around this, let me try to explain what I want to do then maybe you can tell me its possible and how it is possible. I want to create a user that can be creative as he wants... allow him to create ANY databases he wants and delete them if he no longer needs them, but at that same time not be able to mess with ANY other privileges or anyone elses DBs. The only other way I can think of it to compare it to a windows situation. Lets say I'm in Windows and I start up MS Access... Now with me being a Windows user I can create any DB I want and do whatever I want to the DBs I've created (as long as its not in a read only folder) but I can't see or do anything to to the other peoples creations becuase I don't have permissions to do so. Am I going to have to, as root or another super user, create his DBs for him and then give him privileges to them? I just don't get how that sort of situation works in a production environment. But then again in a production environment you don't usually have people just creating DBs at will. Again sorry for my complete lack of understanding on this and stupidity, but my brain just will not wrap itself around this issue. Thanx for all the help so far, Ryan McDougall --- Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] wrote: Dear Ryan, have a look at the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#User_Account_Management With the exception of Paul's book on MySQL, you probably won't find a better explanation of the MySQL privilege system. PLEASE I'M GOING CRAZY trying to figure this out... my book doesn't say anything about what EXACTLY a user can/can't touch with which privilages Just in short: Put this in my.cnf / my.ini: [mysqld] safe-show-database This will prevent MySQL users to see databases to which they have no access privilege. Starting with MySQL 4.0.5a, this have changed. Now, there is a special privilege show_database which is set to N by default. safe-show-database will still work, though. grant select,insert,update,delete,create,drop on somedb.* to someusr@% identified by 'passwrd'; This means, someusr can access the somedb database and all its tables from anywhere (%). someusr can create and drop tables, and might even drop database somedb, but cannot add or drop any other databases. So this should be exactly what you want. If applicable, you may want to restrict the access to something which is not %, but rather something like 192.168.% (e. g. intranet users) or even 62.115.92.78 (if your users have a static ip address). HTH! -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL user privilages
Hey everyone, Ok if I issue this command: mysql grant select,insert,update,delete,create,drop - on *.* to someusr@% identified by 'passwrd'; I already know that this statement creates the user someusr w/ password=passwrd and it can connect from anywhere. What I don't know: Can this user now mess up the privilage tables? Can this user mess with other users DBs and tables? I want to create a normal user for me that can create my own DBs and delete them if I want (it my stuff anyway ) but I don't want me to be able to see or do anything to anybody elses stuff. Would I then have to run this command??? mysql grant select,insert,update,delete,create,drop - on somedb.* to someusr@% identified by 'passwrd'; And create this test DB so that this user can have initial privilages on some DB then that user will be ale to create their own DBs at will?? I just don't get the whole user aspect of MySQL... I want it to be like a normal *nix user create their own crap and delete it if they want... but don't touch whats not theirs! Is this accomplished with either of those commands, if so which one, if not how do I do that? PLEASE I'M GOING CRAZY trying to figure this out... my book doesn't say anything about what EXACTLY a user can/can't touch with which privilages __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Users and Databases
Hi everyone, Please pardon my extreme case of the NEWBs on this but I need some help please. Ok I just purchased a book to hopefully clear things up for me, but to no avail. So this is my dilemma: I want to know about MySQL administration, specifically the user management portion of the admining. I want to be able to allow users to create whatever DBs they need. One DB for my Multi-media collection, one for an address book, one DB for links for a web site. Whatever the case may be! But it seems like I can't give a user the option to create and/or delete any DBs that only user X made. So I the admin would have to create each DB and assign appropriate privileges to appropriate users? So to sum up my situation into a question: Is it possible for me to give a user the ability to create and/or delete only their DBs? Or do I have to make the DB for them and then Grant appropriate privileges for that user to that DB? Thanx in advance for the help __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
