RE: About JDBC
As I understand it, You're actually better off, if not HAVE TO, just putting the 3.0.6 connector jar file into your tomcat-install/common/lib directory in order for Tomcat to be able to see it. K -Original Message- From: Todd O'Bryan [mailto:[EMAIL PROTECTED] Sent: Saturday, 5 April 2003 19:44 To: R Cc: [EMAIL PROTECTED] Subject: Re: About JDBC It should be enough to place the .jar file in the jre/lib/ext folder inside your Java installation folder. If you don't want to do that, you could modify your CLASSPATH environment variable to include wherever you decide to place the .jar. Todd On Saturday, April 5, 2003, at 09:05 AM, wrote: Sorry~ I have a problem about JDBC now, I use mySQL as my database and tomcat as my server I downloaded the JDBC driver (mysql-connector-java-3.0.6-stable.zip) and unziped it, but now I don't how to use it? How to let my jsp pages connect to my database Would u tell me how to do?? thanks a lot!! L.c.Hsu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql 4 search features
Hi guys i messaged before regarding mysql 4's search capabilties, i am doing up a scope for a tape library database change over from access , there is 100,000+ records, i am trying to find the most effiecient way to build the search capabiltiies, there will be fields like title, tx date, reporter, user etc .. the way i design my tables is usually have tables like reporter and user and join with keys ie reporter: reporterID reporter user: userID user program reporterID userID and then join the tables that way , would this slow it down in anyway when doing a search against it , also is match against my best way of doing a boolean search , also the current access db has a keywords field , and then is searchable against that to find the entry quicker would this still be needed , and also with indexing , how many fields can i index at once in a table , and for the content text field , if i remove the keyword search , i would prob need the text in this searchable , would full text indexing speed up the search and how could i achieve this ? let me know thankyou. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: More OS X install fun
on 04/05/2003 10:48 PM, Ken Tozier at [EMAIL PROTECTED] wrote: Has anyone successfully installed mysql-max-4.0.12 on OS X? I've been trying for three days to set the root password and nothing I try seems to work. I'm a total unix newbie but I did go out and buy a Unix book and think I have enough of a feel for it to follow printed directions. It seems to launch ok but when I try to create new databases I get the following error: mysql create test; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'test' at line 1 Not sure whether this is a problem, but running mysql show databases; the terminal seems to hang. The absence of the mysql database seems to be a bad thing as the documentation clearly states mysql database is required because it describes user access privileges does this indicate a fatal install error? Is there a way to roll this file by hand? Thanks Seriously puzzled newbie Any particular reason you are using max? Just use the normal version it runs fine. - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL Newbie
I'm interested in learning about MYSQL and wondered if anyone could give me a few pointers for getting started. I've designed over 1,000 webpages, based at http://www.geobop.com, but my technical skills are very basic. I've been unemployed for about eight months and have been using my time to learn new computer skills while frantically trying to get my websites revised and moved to a new Linux server. I recently graduated from Microsoft FrontPage to DreamWeaver, upgraded from Windows Millennium to XP Professional and have been studying Cascading Style Sheets and JavaScript. I recently got Linux installed on my computer, though I haven't learned to use it yet. I'll be moving to a Linux ISP soon. Here are my first three questions: 1) Can you recommend some good online tutorials for learning the basics of MYSQL? (I can't even say I know exactly what it is; I think of it as some sort of language used to create special effects or special functions, similar to JavaScript.) 2) I recently learned how to create tables with sortable columns using JavaScript, as illustrated by the example at http://www.geobop.com/marini/ I envision using something like MYSQL to create even more sophisticated tables, or alternatives. For example: Suppose I created a table listing every species of bird - about 10,000 species - with a dozen columns for the common name, scientific name, habitat, etc. Obviously, a page with such a table would take forever to download. But someone told me I could use MYSQL or another language to create an alternative that would display only a few rows at a time. I'm not certain exactly what form this function will eventually take, but I'm just exploring ways to list vast amounts of data that are searchable, sortable or can be manipulated in other ways. If this can be done with MYSQL, can you give me an idea of how to get started? Is there a name for this function, a tutorial that describes it, or a webpage on the Internet that I can use as a model? 3) Is a knowledge of MYSQL a great help in finding jobs and roughly how long does it take most people to acquire a working knowledge of it? With my skills, I don't expect to become a MYSQL pro any time soon, but I just wondered if even a basic knowledge might help with job searches. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL access denied
I'm having a problem accessing MySQL via phpMyAdmin. I've inserted in the 1st line of the config.inc.php3 $cfgPmaAbsoluteuri=; I can access MySQL via CLI and I have set the username and password via mysqladmin for the major users. But I'm still getting the following when trying to access the database via a web browser. This is a internal system: Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) Thanks for any insight. -- Jon L. Miller MMT Networks Pty Ltd Perth, Western Australia `When you say I wrote a program that crashed Windows, people just stare at you blankly and say Hey, I got those with the system, *for free*.' - Linus Torvalds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL access denied
this as it says is an incorrect username or password Andrew -Original Message- From: Jon L. Miller [mailto:[EMAIL PROTECTED] Sent: 06 April 2003 10:42 To: [EMAIL PROTECTED] Subject: MySQL access denied I'm having a problem accessing MySQL via phpMyAdmin. I've inserted in the 1st line of the config.inc.php3 $cfgPmaAbsoluteuri=; I can access MySQL via CLI and I have set the username and password via mysqladmin for the major users. But I'm still getting the following when trying to access the database via a web browser. This is a internal system: Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) Thanks for any insight. -- Jon L. Miller MMT Networks Pty Ltd Perth, Western Australia `When you say I wrote a program that crashed Windows, people just stare at you blankly and say Hey, I got those with the system, *for free*.' - Linus Torvalds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.467 / Virus Database: 266 - Release Date: 01/04/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL Newbie
1) Can you recommend some good online tutorials for learning the basics of MYSQL? (I can't even say I know exactly what it is; I think of it as some sort of language used to create special effects or special functions, similar to JavaScript.) If you found this list then you should have found information about MySQL. It's a database server ment for running relational databases. (short and simple explanation). You can use languages like Perl, PHP, Python and C to retrieve information. Tutorials: www.php.net --links-tutorials www.devshed.com www.mysql.com www.google.com (search) search this lists archive since it holds many many many other links. YOu will find hundreds of links if you search google. I'm not certain exactly what form this function will eventually take, but I'm just exploring ways to list vast amounts of data that are searchable, sortable or can be manipulated in other ways. If this can be done with MYSQL, can you give me an idea of how to get started? Is there a name for this function, a tutorial that describes it, or a webpage on the Internet that I can use as a model? You can do this with any language mentioned above. 3) Is a knowledge of MYSQL a great help in finding jobs and roughly how long does it take most people to acquire a working knowledge of it? With my skills, I don't expect to become a MYSQL pro any time soon, but I just wondered if even a basic knowledge might help with job searches. Depends on what a company is looking for. Some basic knowledge usually isn't enough. B. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
root password setting problem
Hello, This is bugging the crap out of me. A few days ago I installed of MySQL 4.0.12 on Windows XP. All's fine (so far), but I can't figure out how to set the root password. I thought I had done it yesterday, but just discovered it didn't take. I've followed the instructions in the MySQL reference manual http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Windows_running , but it never seems to work. I've already done this part: C:\ C:\mysql\bin\mysql mysql mysql DELETE FROM user WHERE Host='localhost' AND User=''; mysql QUIT C:\ C:\mysql\bin\mysqladmin reload And I'm assuming that I don't have to do that again for everytime I try setting the root password, especially since no password has been set yet. Here's what I type, which as I understand, is how I set the root password... C:\mysql\bin\ mysqladmin -u root password onyoung 'onyoung' being my intended password. This isn't working though. So, what am I missing here? Dev _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
unable to change password
Dear sir/madam Please tolerate my poor English. I had been using mysql for a while without any problems. And one day Error occuered ,I could not access it anymore. My password which I had been using has been declined and i have this error Access Denied even though I have never changed password, at least not I am aware of. --- Welcome to Darwin! [Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -p mysql Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -P mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.55-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. - I tried to reset password with code below after I removed startupitem from library and left it at desltop, then typed the following code after restarting computer. but I failed. I do not have any idea why I can not change password. - START- Last login: Sat Apr 5 04:08:11 on console Welcome to Darwin! [Hisako:~] hisako% cd /usr/local/mysql [Hisako:/usr/local/mysql] hisako% sudo echo Password: [Hisako:/usr/local/mysql] hisako% sudo ./bin/safe_mysqld --user=mysql --skip-grant-tables [1] 337 [Hisako:/usr/local/mysql] hisako% Starting mysqld daemon with databases from /usr/local/mysql/data ./bin/mysqladmin -u root password 'hisako' ./bin/mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' [Hisako:/usr/local/mysql] hisako% sudo ./bin/mysqladmin -u root shutdown 030405 04:11:08 mysqld ended [1] + Done sudo ./bin/safe_mysqld --user=mysql --skip-grant-tables [Hisako:/usr/local/mysql] hisako% sudo ./bin/safe_mysqld --user=mysql [1] 365 [Hisako:/usr/local/mysql] hisako% Starting mysqld daemon with databases from /usr/local/mysql/data -- END-- below is information about mysqladmin. - [Hisako:/usr/local/mysql] hisako% sudo ./bin/mysqladmin variables extended -status processlist +- +--- + | Variable_name | Value | +- +--- + | back_log| 50 | | basedir | /usr/local/mysql/ | | binlog_cache_size | 32768 | | character_set | latin1 | | character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | | concurrent_insert | ON | | connect_timeout | 5 | | datadir | /usr/local/mysql/data/ | delay_key_write | ON | | delayed_insert_limit| 100 | | delayed_insert_timeout
RE: MYSQL Newbie
you probably want php which intergrates into mysql nicely, as mysql being the database for the content, http://www.php.net/ http://www.phpbuilder.com/ there is also some links on the php site u might want to check out http://www.php.net/links.php with mysql you prob want to master the sql queries to get the most optimised way to retrieve your data. these sites are good has alot of resources and helped me alot when i was a newbie http://www.weberdev.com/ http://www.devshed.com/ = Original Message From David Blomstrom [EMAIL PROTECTED] = I'm interested in learning about MYSQL and wondered if anyone could give me a few pointers for getting started. I've designed over 1,000 webpages, based at http://www.geobop.com, but my technical skills are very basic. I've been unemployed for about eight months and have been using my time to learn new computer skills while frantically trying to get my websites revised and moved to a new Linux server. I recently graduated from Microsoft FrontPage to DreamWeaver, upgraded from Windows Millennium to XP Professional and have been studying Cascading Style Sheets and JavaScript. I recently got Linux installed on my computer, though I haven't learned to use it yet. I'll be moving to a Linux ISP soon. Here are my first three questions: 1) Can you recommend some good online tutorials for learning the basics of MYSQL? (I can't even say I know exactly what it is; I think of it as some sort of language used to create special effects or special functions, similar to JavaScript.) 2) I recently learned how to create tables with sortable columns using JavaScript, as illustrated by the example at http://www.geobop.com/marini/ I envision using something like MYSQL to create even more sophisticated tables, or alternatives. For example: Suppose I created a table listing every species of bird - about 10,000 species - with a dozen columns for the common name, scientific name, habitat, etc. Obviously, a page with such a table would take forever to download. But someone told me I could use MYSQL or another language to create an alternative that would display only a few rows at a time. I'm not certain exactly what form this function will eventually take, but I'm just exploring ways to list vast amounts of data that are searchable, sortable or can be manipulated in other ways. If this can be done with MYSQL, can you give me an idea of how to get started? Is there a name for this function, a tutorial that describes it, or a webpage on the Internet that I can use as a model? 3) Is a knowledge of MYSQL a great help in finding jobs and roughly how long does it take most people to acquire a working knowledge of it? With my skills, I don't expect to become a MYSQL pro any time soon, but I just wondered if even a basic knowledge might help with job searches. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unable to change password
try: mysql -u root -p then it will ask for your password. or mysql -u root -pmysql_root_password no spaces between -p and your mysql root password This is well documentee :http://www.mysql.com/doc/en/User_names.html please check the manual before asking questions. B. At 12:50 06-04-2003 +0100, Hisako Shimizu wrote: Dear sir/madam Please tolerate my poor English. I had been using mysql for a while without any problems. And one day Error occuered ,I could not access it anymore. My password which I had been using has been declined and i have this error Access Denied even though I have never changed password, at least not I am aware of. --- Welcome to Darwin! [Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -p mysql Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -P mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.55-entropy.ch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unable to change password
[Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -p mysql Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) This is the same thing that was happening to me! Then I discovered that my root password was not set, even though I did everything that was supposed to do, according to the manual. Devon _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unable to change password
At 08:28 06-04-2003 -0400, Devon Y. wrote: [Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -p mysql Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) This is the same thing that was happening to me! Then I discovered that my root password was not set, even though I did everything that was supposed to do, according to the manual. The manual tells you to set a root password. You wrote: C:\mysql\bin\ mysqladmin -u root password onyoung If it's the same on windooz as on Linux then it should be: mysqladmin -u root -ponyoung Don't know what good it would do to just run mysqladmin like that but that's how it should look like.. But perhaps there is a difference between the Linux and the windooz version.. If you really messed up you can reset the mysql root password: http://www.mysql.com/doc/en/Resetting_permissions.html Have fun, B. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
My SQL OS X setup - utterly, completely, 100% stumped
Anyone willing to help a newbie walk through setup and install? I've tried everything specified in the online documentation, the tips on Marc Lynnage's page, install tips in several MySQL books multiple times. I've read all error messages and tried my best to figure out how to work around them. Absolutely nothing works. I can't set the root password, there is no 'mysql' table after the install, can't create new databases, can't reset the root password by following the instructions at: http://www.mysql.com/doc/en/Resetting_permissions.html I don't have the $700 dollars for the commercial license at the moment and can't stomach paying that much just to learn how to get MySQL running and be able to create new tables. I've been a Macintosh C programmer for 7 years and after that, being unable to get a database running after following the instructions to the letter has me rather stumped. Any Unix/MySQL experts willing to spend a 15 minutes or so on AIM to help me out? Thanks Ken Tozier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My SQL OS X setup - utterly, completely, 100% stumped
You don't explain your problem. You don't even tell which versions you're running. If there is no mysql table then you didn't create it, or you trashed it. In the manual you will find references to how to install MySQL on MAC OS X. http://www.mysql.com/doc/en/Mac_OS_X_installation.html IMHO your problem needs to be solved via the list. That way someone else can learn from the problem and others don't have to ask the same question over and over. You did search the archive.. right? B. At 10:11 06-04-2003 -0400, Ken Tozier wrote: Anyone willing to help a newbie walk through setup and install? I've tried everything specified in the online documentation, the tips on Marc Lynnage's page, install tips in several MySQL books multiple times. I've read all error messages and tried my best to figure out how to work around them. Absolutely nothing works. I can't set the root password, there is no 'mysql' table after the install, can't create new databases, can't reset the root password by following the instructions at: http://www.mysql.com/doc/en/Resetting_permissions.html I don't have the $700 dollars for the commercial license at the moment and can't stomach paying that much just to learn how to get MySQL running and be able to create new tables. I've been a Macintosh C programmer for 7 years and after that, being unable to get a database running after following the instructions to the letter has me rather stumped. Any Unix/MySQL experts willing to spend a 15 minutes or so on AIM to help me out? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My SQL OS X setup - utterly, completely, 100% stumped
On Sunday, April 6, 2003, at 10:28 AM, B. van Ouwerkerk wrote: You don't explain your problem. First problem is that after doing a clean install of mysql-standard-4.0.12 and following the instructions cd /usr/local/mysql sudo ./bin/mysqld_safe (Enter your password) (Press CTRL+Z) bg (Press CTRL+D to exit the shell) Then attempting to set the root password as recommended: /usr/local/mysql/bin/mysqladmin -u root password 'new-password' which runs without error followed by: /usr/local/mysql/bin/mysqladmin -u root -h $hostname password 'new-password' which fails with an error of hostname: Undefined variable. An earlier post by Lenz Grimmer mentions a possible issue with the hostname variable so I tried hard coding the host name as follows: // get the host name [my-computer:~] my-user-name% hostname my-computer.local. // use it to set the password [my-computer:~] my-user-name% /usr/local/mysql/bin/mysqladmin -u root -h my-computer.local. password mypassword /usr/local/mysql/bin/mysqladmin: connect to server at 'my-computer.local.' failed error: 'Host '10.0.1.5' is not allowed to connect to this MySQL server' [my-computer:~] my-user-name% Also tried to run (without the hostname field) which yielded: [my-computer:~] my-user-name% /usr/local/mysql/din/mysqladmin -u root password mypassword /usr/local/mysql/din/mysqladmin: Command not found. [my-computer:~] my-user-name% At this point, my limited unix skills run out, what now? You don't even tell which versions you're running. mysql-standard-4.0.12 on Mac OS 10.2.3 If there is no mysql table then you didn't create it, or you trashed it. I didn't create it, true, but the documentation never says to do so. I assumed the package installer would handle this as part of the install. Does everyone need to create this table manually? Definitely didn't trash it as I didn't issue any rm's or manual deletes in the finder after install, so my suspicion is the installer just doesn't make one. In the manual you will find references to how to install MySQL on MAC OS X. http://www.mysql.com/doc/en/Mac_OS_X_installation.html Already followed these to the letter at least 4 times, can't set the password no way no how. without the root password, I can't create any new databases so everything else is just academic. IMHO your problem needs to be solved via the list. That way someone else can learn from the problem and others don't have to ask the same question over and over. I would definitely post the full solution and might even whip up a web page for other mac users You did search the archive.. right? Yep One possible problem might be that in my users and groups control panel, attempting to set a mysql user fails with the error: user mysql already exists even though it doesn't show up. Might be an old instance from when I tried MySQL a few months ago (also with no luck) Best I can tell, there wasn't any other mysql files on the system, I deleted them all prior to the install with rm's
