Re: mysqldev user ?
On Wed, 2003-09-10 at 16:36, Lenz Grimmer wrote: > -BEGIN PGP SIGNED MESSAGE- > > warning: user mysqldev does not exist - using root > > warning: user mysqldev does not exist - using root > > This is a warning, not an error. Did the install continue? Where exactly > did you get this message? Does MySQL run? You're right.. it didn't stop the process, but did cause the warning.. > The myslqdev user account is being used on our Linux build machine to > create the RPMs. I have no idea how it could have ended up in the RPMs - > all file ownerships should be set to root:root. Hrm... I tried to repro this by upgrading from 4.0.13 to 4.0.15 on another machine and was unable to... Aha... I think I figured it out... I have the MySQL-4.0.15-0.src.rpm in the same directory... I'll bet that an rpm -Fvh automatically installs the source.. The source is "owned" by mysqldev, isn't it... :) > I can't really find a reason for this without having more details. But in > any case, it's probably harmless. Yup, appears to be... Thanks for the info though! > Bye, > LenZ > - -- > Lenz Grimmer <[EMAIL PROTECTED]> > Senior Production Engineer > MySQL GmbH, http://www.mysql.de/ > Hamburg, Germany > > For technical support contracts, visit https://order.mysql.com/?ref=mlgr > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) > Comment: For info see http://quantumlab.net/pine_privacy_guard/ > > iD8DBQE/X4tjSVDhKrJykfIRAk7DAJ9XyXLy4PF35dRedlJs1VNHSDEAFQCbB+vo > j5YTOaqyMUSpWkmQfQj0nK4= > =s6DC > -END PGP SIGNATURE- -- --- Jason H. Frisvold Backbone Engineering Supervisor Penteledata Engineering [EMAIL PROTECTED] RedHat Engineer - RHCE # 807302349405893 Cisco Certified - CCNA # CSCO10151622 MySQL Core Certified - ID# 205982910 --- "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." -- Albert Einstein [1879-1955] signature.asc Description: This is a digitally signed message part
mysqldev user ?
All, I recently updated the RPM files on my Linux box to 4.0.15 ... During the update, I received the following error : warning: user mysqldev does not exist - using root warning: user mysqldev does not exist - using root Can someone please explain to me what this user is and what it's being used for? This was generated during the update of the MySQL-shared RPM. If I'm missing out on increased security because of this, I really want to know! I checked the release notes, but I don't see anything in there related to this user... Thanks! -- --- Jason H. Frisvold Backbone Engineering Supervisor Penteledata Engineering [EMAIL PROTECTED] RedHat Engineer - RHCE # 807302349405893 Cisco Certified - CCNA # CSCO10151622 MySQL Core Certified - ID# 205982910 --- "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." -- Albert Einstein [1879-1955] signature.asc Description: This is a digitally signed message part
Optimizing with TEXT fields
Hi all, I'm in the process of designing a database and I'm a bit of an optimization freak ... I'd like to make sure that the actual structure of the database is optimal. With that said, my question is about TEXT fields. In the actual CREATE TABLE statement, would it make the table "faster" if the TEXT fields were at the end of the table definition? In fact, should VARCHAR fields be there as well? Thanks, -- --- Jason H. Frisvold Backbone Engineering Supervisor Penteledata Engineering [EMAIL PROTECTED] RedHat Certified - RHCE # 807302349405893 MySQL Core Certified - ID# 205982910 --- "Something mysterious is formed, born in the silent void. Waiting alone and unmoving, it is at once still and yet in constant motion. It is the source of all programs. I do not know its name, so I will call it the Tao of Programming." signature.asc Description: This is a digitally signed message part
Continuing a previous selection
I want to select a large amount of data from the database, but I can't use it all at once. Is there a way to "pick up where I left off" and get another X rows of data? For instance, suppose I have the following table in a database : CREATE TABLE namelist (nameid INTUNSIGNEDNOT NULL PRIMARY KEYAUTO_INCREMENT, First_Name CHAR(50), Last_NameCHAR(50)) This table has 500 rows. I want to select the data, order it by last name, and limit the select to 10 rows at a time. After I display this data, I want to be able to go to the next 10 rows ... Or, perhaps view the data and select to jump 50 rows ahead ... My initial thought was to use the nameid field to do this, however, I cannot since I'm ordering the data.. There is no way to be certain that the order that comes out keeps the nameid values in order ... So how is this accomplished? I see it done all over the place, but I have no idea how to do this on my own ... The program that will be doing this is written in perl using the perl DBI and the mySQL DBD... Any help would be greatly appreciated...! -- --- Jason H. Frisvold Senior ATM Engineer Penteledata Engineering [EMAIL PROTECTED] RedHat Certified - RHCE # 807302349405893 --- "Something mysterious is formed, born in the silent void. Waiting alone and unmoving, it is at once still and yet in constant motion. It is the source of all programs. I do not know its name, so I will call it the Tao of Programming." - 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
Major MySQL Server Problems
Greetings, We're experiencing some severe problems with MySQL and I'm at a loss as to what to look at ... It seems we've encountered some sort of a loop but I'm not sure what's causing it. The system will run fine for a while and then begin using 100% cpu on both processors in the system. We've spent several days trying to track it down and I believe we may have found the process responsible, but I haven't seen anything at all in that process that's suspect. It's a fairly simple perl script that generates some email addresses via the db. It has to use several different db's to do so, but again, I can't see it putting a lot of load on the system doing this. Can anyone help me pinpoint this problem? It's causing the entire DB to run extremely slow and because of this we sometimes lose data. Killing and restarting the DB speeds it back up, but I believe this is because it kills those DB connections and the processes fail. The system is a Dell PowerEdge 2650 Dual 1.4 Ghz Intel P3 Processors 512 Meg RAM MySQL 3.23.52 RedHat Linux 7.3 Hardware Raid 5 The DB partition is 4 GB, only 300 Meg used. Overall, the HD's are less than 50% full. Any help or suggestions are gladly welcome! Thanks, -- --- Jason 'XenoPhage' Frisvold Senior ATM Engineer Penteledata Engineering [EMAIL PROTECTED] RedHat Certified - RHCE # 807302349405893 --- "Something mysterious is formed, born in the silent void. Waiting alone and unmoving, it is at once still and yet in constant motion. It is the source of all programs. I do not know its name, so I will call it the Tao of Programming." - 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 Stability Problem
Hi all, I seem to be running into a stability problem with our current mySQL server. I'm at a loss as to where to begin looking. We first noticed a problem with large files being created in the /tmp directory. That hasn't happened since, but yesterday the server bogged down twice. There were about 100 or so connections to the server, mostly sleeping, and the server was acting extremely sluggish. It took about 60 seconds to get a processlist via mysqladmin... Can anyone give me any pointers as to where to look first? Are there any settings I can tweak that may help this? The machine is a dual 1.3 Ghz machine with 512 Meg RAM It used to be running on a dual 733 Mhz machine and we never experienced anything like this ... -- --- Jason 'XenoPhage' Frisvold Senior ATM Engineer Penteledata Engineering [EMAIL PROTECTED] RedHat Certified - RHCE # 807302349405893 --- "Something mysterious is formed, born in the silent void. Waiting alone and unmoving, it is at once still and yet in constant motion. It is the source of all programs. I do not know its name, so I will call it the Tao of Programming." - 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: RPM Installation Question
Excellent info... thanks... (a little late response, but there was no net access in the woods... :P) Thanks again! --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata RedHat Engineer - RHCE # 807302349405893 Cisco Certified - CCNA # CSCO10151622 [EMAIL PROTECTED] --- "I love deadlines. I especially like the whooshing sound they make as they go flying by." -- Douglas Adams [1952-2001] -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 1:01 PM To: MYSQL-List (E-mail) Subject: RE: RPM Installation Question read the documentation in the my.cnf sections you can supply datadir=/usr/data/mysql (or whatever the data directory you choose) make sure mysql has permissions on the new directory a couple other things rely on this base directory too your socket file your pid file You can set these too in your /etc/my.cnf pid-file=/usr/data/mysql/mysql.pid socket=/tmp/mysql.sock or some such directories Your err files will write to the datadir you specify > -Original Message- > From: Jason Frisvold [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 01, 2002 11:25 AM > To: [EMAIL PROTECTED] > Subject: RPM Installation Question > > > I was hoping to use the RPM distribution to install MySQL on > my Linux machine. However, I notice that it sets the data > directory to /var/lib/mysql ... This is unacceptable for my > purposes... I know I can probably use a link to fix this, > but I'd rather do it the "right" way... How do I tell mySQL > where the data directory is? Is this a compiled option? > > Thanks, > > --- > Jason H. Frisvold > Senior ATM Engineer > Engineering Dept. > Penteledata > RedHat Engineer - RHCE # 807302349405893 > Cisco Certified - CCNA # CSCO10151622 > [EMAIL PROTECTED] > --- > "Imagination is more important than knowledge. Knowledge is > limited. Imagination encircles the world." -- Albert Einstein > [1879-1955] > > > - > 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 > > - 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 - 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
RPM Installation Question
I was hoping to use the RPM distribution to install MySQL on my Linux machine. However, I notice that it sets the data directory to /var/lib/mysql ... This is unacceptable for my purposes... I know I can probably use a link to fix this, but I'd rather do it the "right" way... How do I tell mySQL where the data directory is? Is this a compiled option? Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata RedHat Engineer - RHCE # 807302349405893 Cisco Certified - CCNA # CSCO10151622 [EMAIL PROTECTED] --- "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." -- Albert Einstein [1879-1955] - 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: Auto Increment Fields
Thanks everyone.. That's exactly what I needed :) --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." -- Albert Einstein [1879-1955] -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 4:37 PM To: Jason Frisvold; '[EMAIL PROTECTED]' Subject: Re: Auto Increment Fields At 4:08 PM -0400 10/4/01, Jason Frisvold wrote: >Is there a way to have DBI return the value of the auto-incremented field >upon insert? Or do I have to insert and then do a select afterwards? $dbh->do ("your insert statement"); $auto_inc = $dbh->{mysql_insertid}; -- Paul DuBois, [EMAIL PROTECTED] - 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
Auto Increment Fields
Is there a way to have DBI return the value of the auto-incremented field upon insert? Or do I have to insert and then do a select afterwards? Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "So Long and Thanks for all the Fish" -- Douglas Adams [1952-2001] sql - 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 Queries
Setup : MySQL 3.23.42 Perl 5.6.0 DBI 10.32 I’m trying to do a few different queries where the table name needs to be dynamic. I’ve tried the following : $dbquery = $dbhandler->prepare_cached(“SELECT id, target FROM ? where somedata=?”); $dbquery->execute($tablename,$somedata); But I keep getting an error…. The error looks something like this : DBD::mysql::st execute failed: You have an error in your SQL syntax near ''mod1' where id='test.1'' at line 1 at ClassMRTGDB.pm line 73. DBD::mysql::st fetchrow_array failed: fetch() without execute() at ClassMRTGDB.pm line 75. Anyone know why this isn’t working? Do I have to specify the table name in the actual prepare statement every time? Also, assuming I only run execute’s after I first define $dbquery, is $dbquery guaranteed to be there until the program exits? (I’m not redefining $dbquery at any time…) I’m pretty sure it is, so I’m just checking.. Otherwise I need to write code to check on it.. ☺ Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "So Long and Thanks for all the Fish" -- Douglas Adams [1952-2001] - 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 - 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: Last Modified function?
I know you can set a column in each table that will update itself with the current ctime every time that row is modified, but I haven't found a per db, or per table variable yet. (I believe mSQL has something like this, but not mysql. --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." -- Albert Einstein [1879-1955] -Original Message- From: Camilo Rostoker [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 9:41 PM To: [EMAIL PROTECTED] Subject: Last Modified function? Hi. I was wondering if there was a way to find out when the last time the database was modified? (like a last modified function for a webpage?). Thanks for the help. Regards, Camilo Rostoker -- +=+ Camilo Rostoker [EMAIL PROTECTED] http://www.rostoker.com/ The 2 most important things in life: 1. never tell anyone everything you know about something 2. ... +=+ - 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 - 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
REPLACE vs INSERT/UPDATE
Currently I'm checking to see if a value exists in the database before deciding whether to update it or insert it. Would this be quicker to do if I merely used REPLACE? Is that the purpose of the REPLACE command? If it exists, just update it, and if it doesn't exist, insert it? Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "So Long and Thanks for all the Fish" -- Douglas Adams [1952-2001] - 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 List Bounce Message?
That would explain it... I appreciate the prompt replies :) Thanks! sql --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." -- Albert Einstein [1879-1955] - 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 List Bounce Message?
Can anyone explain why I'm getting a "Mail account is disabled" message from [EMAIL PROTECTED] regarding anything I post to the mysql list? The body of the message says : The mail account ([EMAIL PROTECTED]) is currently disabled, and is not receiving mail at this time. Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "So Long and Thanks for all the Fish" -- Douglas Adams [1952-2001] - 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: Post-install
Try this : /usr/bin/mysqladmin -u root -p password '22' The first instance of 'password' is a command.. It doesn't mean you need to replace it with the password.. --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." -- Albert Einstein [1879-1955] -Original Message- From: mysql mysql [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 2:51 PM To: [EMAIL PROTECTED] Subject: Post-install Just installed mssql and in the end of the installation I receive the message taht now is the time to change root password for the db using mysqladmin using the following synthax: /usr/bin/mysqladmin -u root -p password 'new password' So issued the following command: /usr/bin/mysqladmin -u root -p qazwsx 22 (qazwsx is my current root password in OS, 22 is desired password for sql ) Then I see the prompt: Enter password:(which password?) I enter 22 (I tried qazwsx either) I receive the error message: error: Access denied for user 'root@localhost' (Using password: YES)' - 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 - 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 Queries
Setup : MySQL 3.23.42 Perl 5.6.0 DBI 10.32 I’m trying to do a few different queries where the table name needs to be dynamic. I’ve tried the following : $dbquery = $dbhandler->prepare_cached(“SELECT id, target FROM ? where somedata=?”); $dbquery->execute($tablename,$somedata); But I keep getting an error…. The error looks something like this : DBD::mysql::st execute failed: You have an error in your SQL syntax near ''mod1' where id='test.1'' at line 1 at ClassMRTGDB.pm line 73. DBD::mysql::st fetchrow_array failed: fetch() without execute() at ClassMRTGDB.pm line 75. Anyone know why this isn’t working? Do I have to specify the table name in the actual prepare statement every time? Also, assuming I only run execute’s after I first define $dbquery, is $dbquery guaranteed to be there until the program exits? (I’m not redefining $dbquery at any time…) I’m pretty sure it is, so I’m just checking.. Otherwise I need to write code to check on it.. ☺ Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "So Long and Thanks for all the Fish" -- Douglas Adams [1952-2001] - 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
Update TimeStamp
Is there any way to query a mySQL database for the last time it was updated? I need this ability to trigger a "restart" in some other applications that create config files and such for MRTG... Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "It is a silly, childish discussion and only exposes the want of brains of those who maintain a contrary opinion to that we have stated." - The Times (London) December 26, 1799 - 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
Database Permissions
Greetings, I'm having a little trouble understanding how the permissions work within mySQL. I have 3 current databases. The first is the default mysql database, and the other 2 are ones that I have created. I want to be able to grant access to each table individually based on username. Hostname isn't really a big deal to me because of the firewalls. Basically, if they can get to the database server, then they belong there. But, I want to limit what they can get to via username. So, I tried the following : insert into user (host, db, user, select_priv, insert_priv, update_priv, delete_priv) values ('%', 'myuser', password('mypass'), 'Y', 'Y', 'Y', 'Y'); insert into db (host, db, user, select_priv, insert_priv, update_priv, delete_priv) values ('%', 'database1', 'myuser', 'Y', 'Y', 'Y', 'Y'); insert into db (host, db, user, select_priv, insert_priv, update_priv, delete_priv) values ('%', 'mysql', 'myuser', 'N', 'N', 'N', 'N'); flush privileges; I *thought* this would allow access to database1, and not mysql, but apparently I was wrong... I can still access the mysql database, make changes, etc. without any restrictions. What am I doing wrong???!!!??? Also.. Is there a way to allow a user to connect to the mySQL server, not specifying a database (this is via Perl and DBI), and get a list of databases that they have permissions to? (What I'd like to do is let them list all db's except those they have no permissions on...) I have it working so that they can list all the databases, but it will list everything on the server.. (This may be a moot point when I get actual permissions to work...) --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "We should take care not to make the intellect our god; it has, of course, powerful muscles, but no personality." - Albert Einstein (1879-1955) - 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 Tables over Multiple Drives
Well, there are a few reasons.. We have a system with 4 8G drives.. If we use one for root and one to mirror that root, we have 2 drives left. Now, if we raid those 2 remaining drives (RAID5) we get about 12 Gigs of space available... If we merely use one of the remaining drives completely, and use the last one to mirror it, we have 8 gigs available. On the root drive, however, there will be an additional 4 gigs of space not used.. so again, we're at 12 gigs, but with a higher redundancy value. So, I want to be able to put tables in /mysql/data (8 gig mirrored) and /data (4 gig mirrored on the root drive) so I can still use 12 gigs of space with better redundancy... As an aside here, does anyone have any decent information on Linux software raids? We have been having a large problem with them failing for no apparent reason and I've lost enough data to last me a lifetime... (all backed up now...) --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "I love deadlines. I especially like the whooshing sound they make as they go flying by." -- Douglas Adams -Original Message- From: Sam Wong [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 6:32 AM To: [EMAIL PROTECTED] Subject: Re: MySQL Tables over Multiple Drives Yes, you've to recreate the tables with RAID option (read the manual for details) and move and link the directoris manually. I think there may be a performance gain, instead of performance hit...Because as the file spread on diff discs, the seek time gain. The code should has been stablize already, I think. BTW, why you want it to span over multiple drive? - Original Message ----- From: "Jason Frisvold" <[EMAIL PROTECTED]> To: "'Sam Wong'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 7:15 PM Subject: RE: MySQL Tables over Multiple Drives > Sam, > > Thanks for the reply.. Is that a stable way of doing things? Is > there a performance hit when using the --with-raid option? > > I assume I will need to move the files manually and link them > manually as well? > > --- > Jason H. Frisvold > Senior ATM Engineer > Engineering Dept. > Penteledata > CCNA Certified - CSCO10151622 > [EMAIL PROTECTED] > --- > "I love deadlines. I especially like the whooshing sound they make as they > go flying by." -- Douglas Adams > > > -Original Message- > From: Sam Wong [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 30, 2001 5:41 AM > To: [EMAIL PROTECTED] > Subject: Re: MySQL Tables over Multiple Drives > > > Compile mysql with --with-raid option, then use symbolic link to link it to > other drive > > - Original Message - > From: "Jason Frisvold" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, January 30, 2001 6:33 PM > Subject: MySQL Tables over Multiple Drives > > > > I looked through the manual briefly and did not see this addressed > > anywhere.. Is it possible to have a table span over multiple drive > without > > a raid? Or perhaps possible to specify a directory where a table will > > reside other than the default directory? > > > > Thanks, > > > > --- > > Jason H. Frisvold > > Senior ATM Engineer > > Engineering Dept. > > Penteledata > > CCNA Certified - CSCO10151622 > > [EMAIL PROTECTED] > > --- > > "I love deadlines. I especially like the whooshing sound they make as they > > go flying by." -- Douglas Adams > > > > > > - > > 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 > > > > > > > > > - > 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 > > - Before posting, please check: http://www.mysq
RE: MySQL Tables over Multiple Drives
Sam, Thanks for the reply.. Is that a stable way of doing things? Is there a performance hit when using the --with-raid option? I assume I will need to move the files manually and link them manually as well? --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "I love deadlines. I especially like the whooshing sound they make as they go flying by." -- Douglas Adams -Original Message- From: Sam Wong [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 5:41 AM To: [EMAIL PROTECTED] Subject: Re: MySQL Tables over Multiple Drives Compile mysql with --with-raid option, then use symbolic link to link it to other drive - Original Message ----- From: "Jason Frisvold" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 6:33 PM Subject: MySQL Tables over Multiple Drives > I looked through the manual briefly and did not see this addressed > anywhere.. Is it possible to have a table span over multiple drive without > a raid? Or perhaps possible to specify a directory where a table will > reside other than the default directory? > > Thanks, > > --- > Jason H. Frisvold > Senior ATM Engineer > Engineering Dept. > Penteledata > CCNA Certified - CSCO10151622 > [EMAIL PROTECTED] > --- > "I love deadlines. I especially like the whooshing sound they make as they > go flying by." -- Douglas Adams > > > - > 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 > > > - 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 - 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 Tables over Multiple Drives
I looked through the manual briefly and did not see this addressed anywhere.. Is it possible to have a table span over multiple drive without a raid? Or perhaps possible to specify a directory where a table will reside other than the default directory? Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "I love deadlines. I especially like the whooshing sound they make as they go flying by." -- Douglas Adams - 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
Front End Needed
I know it's not "correct" to just jump in and ask and I apologize, but I'm under a bit of a time crunch here... I need to find a web front end that I can use to update a table in MySQL. What I'm looking for is a program that will display an entire table with records as a web page for editing. Something like a submit button at the bottom to send in the updates to the server. Does something like this exist? If not, is there a front end that I can use to first search for a specific record(s), and then edit that record(s) My eventual plan is to write a robust front end to take care of this, but for now, I need something that I can use temporarily until I can complete the rest of this project. I'm not worried about speed at all since the tables are only updated once in a while. The problem is, there are other people that update the tables and SQL is nothing more than voodoo magic to them... TIA! --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "We should take care not to make the intellect our god; it has, of course, powerful muscles, but no personality." - Albert Einstein (1879-1955) - 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