MySQL Database Forum

I can only log into MySQL using Webmin. I MUST have login from command line. All I can get from the command line is 'Cannot access user_name@localhost.' I had previously had no problem. Somethings gone haywire.

I have this query: SELECT * FROM news_category LEFT JOIN news_x_cat ON news_category.id = news_x_cat.cat_id WHERE ( news_x_cat.news_id = 9 OR news_x_cat.news_id IS NULL ) Which gives me this output:

Hi folks, trying to set up replication and I'm getting this problem which I can't see how to fix despite reading of the manual and google. I have set up a master and a slave according to the manual. The master runs 4.0.12 and the slave runs 4.0.14, they are both actually on the same machine (it's a long story, but it's what I need). I...

I am using cold fusion to make a small custom website using mysql to store the information a user inputs. I want it to be able to save japanese and unicode text, but whenever I enter any it comes back as garbage. Is there anything special I need to do to configure mysql to use unicode? Thanks! -Adam -- MySQL General Mailing List

Hi list, I've got a little bug with MySQL. I can insert a row into my table but this row will not appear in the table :( Server is under linux redhat, MySQL is 3.23.56 installed from binary tar.gz from MySQL team. Table Description : mysql> desc Log_Forums;

Thank you for the information about LIKE and equal. I have another question. What is better/quicly 50 simultaneously query/update at the same time from 50 different users or 50 simultaneously query/update at the same time from one user? Thanks for your information in advanced,

Is it possible to MERGE innodb tables? Can't find docs on mysql.com In replication. I guess I can update the slave if the master is not responding, right? Shall I 'stop slave' before , in case the master is down? Also will this create problems when the master comes back and the slave copies updates from the master log file? ...

Hi, I am trying to install myql on redhat. mysql package used: mysql-3.23.52-unknown-freebsdelf4.6-i386.tar.gz While following the instructions in install document..when i run the follwing command.. scripts/mysql_install_db following errors appear: -------------

Hi using InnoDB tables in a MySQL 3.23.54-max environment on the usual linux/apache/PHP4.3.0 server. I have complete control over the box. I'm creating an e-commerce book shop (<500 titles), and am now thinking about the functionality of the SEARCH box. Am looking for inspiration!

------_=_NextPart_001_01C35BD2.6BADEC7D Content-Type: text/plain Hi, I am a Sun solaris 5.6 user. I do not have su or any other system permissions We have PERL5.005 on the box

Hello, I have a table which has a foreign key relationship with itself. I want and expect my updates to cascade (deletes definitely cascade as expected) but instead I just get error 1217: foriegn key error. I have written example code to use in reproducing the problem: # Create the table

When installing the rpms (or the tar file) onto Red Hat Enteprise Linux AS Beta 1 (Taroon), we get the follwing error: Installing all prepared tables /usr/bin/mysql_install_db: line 1: 7690 Segmentation fault /usr/sbin/mysqld --bootstrap --skip-grant-tables --basedir=/ --datadir=/var/lib/mysql --skip-innodb --skip-bdb Installation of...

Hi, I know that Mysql handles large database very well, but there is a project that requires more than 2000 small databases(about 20 talbes with a few rows) to be created within a Mysql server. Could somebody tell me does it make sense? Thanks for your consideration. likai ...

Hi guys I was just wondering, im designing a shopping cart for my own site using php/mysql. I have my design like this. I have one table for the protuct that has a collum for product type. Product type is another table that has links to other tables like motherboards, hard drives etc. I hope you understand this. Is that the easyest, most...

Hi guys I was just wondering, im designing a shopping cart for my own site using php/mysql. I have my design like this. I have one table for the protuct that has a collum for product type. Product type is another table that has links to other tables like motherboards, hard drives etc. I hope you understand this. Is that the easyest, most...

I solved the problem--I needed ( ) around the column list. I think the manual should make that more clear. -------- Original Message -------- Subject: column privilege problem Date: Tue, 05 Aug 2003 15:39:54 -0700 From: Tiffany Wilkes <tdwilkes@ucdavis.edu> To: mysql@lists.mysql.com

Hi, I am having problems granting column privileges. I want to grant the update privilege (only) to a column (called pass) in a table (called Acct). Here's what I get: mysql> grant update pass on practicedb.Acct to JohnDoe@localhost; ERROR 1064: You have an error in your SQL syntax near 'pass on practicedb.Acct to JohnDoe@localhost' at...

I solved the problem--I needed ( ) around the column list. I think the manual should make that more clear. -------- Original Message -------- Subject: column privilege problem Date: Tue, 05 Aug 2003 15:39:54 -0700 From: Tiffany Wilkes <tdwilkes@ucdavis.edu> To: mysql@lists.mysql.com

Hi, I am having problems granting column privileges. I want to grant the update privilege (only) to a column (called pass) in a table (called Acct). Here's what I get: mysql> grant update pass on practicedb.Acct to JohnDoe@localhost; ERROR 1064: You have an error in your SQL syntax near 'pass on practicedb.Acct to JohnDoe@localhost' at...

I just did a major insert of new data and now all my selects have slowed down. The table is innodb. Is there a way to reindex everything without having to drop anything. Otherwise, I suppose I will have to drop the indexes and remake them. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: ...

I just did a major insert of new data and now all my selects have slowed down. The table is innodb. Is there a way to reindex everything without having to drop anything. Otherwise, I suppose I will have to drop the indexes and remake them. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: ...

Hello, Could do with a bit of advice regarding left joins, would be much appreciated! OK, I have a table of products. I wish to have another table of images (filenames only) and a third table which links products to images (i.e: productID | imageID only). So... if I do a select like this:

Hello, Could do with a bit of advice regarding left joins, would be much appreciated! OK, I have a table of products. I wish to have another table of images (filenames only) and a third table which links products to images (i.e: productID | imageID only). So... if I do a select like this:

When I try to import a text file with new data for an existing table I get the error "1148 - the used command is not allowed with this MySQL version." I have tried with both PHPMyAdmin2.3 and with MySQLFront 2.5. Both these GUI programmes have an "import from text file" command which I have used successfully several times to add entries to...

Hi Everyone; As I was perusing the MySQL documentation, I noticed that there is a lack of documentation regarding the MySQL SET datatype and the queries used to manipulate it. In fact, the comments are longer than the documentation. A google search shows a similar lack up information regarding SET. I have therefore added a new article to my...