MYSQL :: Error Configuring Mysql?

Error Configuring PhpMyAdmin
I'm trying to install phpMyAdmin on a test server. I am using the GUI to create the configuration script.I would like to use HTTP mothod for authentication. As the guide says, I need to create a user and grant some privileges to the user. Here is the problem.
mysql -u root -p
INSERT INTO `user` (Host, User, Password) VALUES('localhost','pma',PASSWORD('something'));
Next I try to grant privileges, but receive an error:

GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'something';

Error 1133 (42000) Can't find any matching row in the user table.
Now I know the user is there...If I do

SELECT * FROM `user` WHERE User='pma';

I get results, 1 row in set. The password is encrypted, but I did double check with the original user creation line and it is the same and typed in correctly. localhost is also there.So why is it not finding any user when I want to grant privileges?

Configuring MySQL On Mac OS X
I recently tried to install MySQL on Mac OS X box using these instructions on the Mac site (http://developer.apple.com/internet/macosx/osdb.html). All was working fine until I got to this part here:

./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/run/mysql_socket --with-mysqld-user=mysql --with-comment --with-debug

I got a bunch of "file not found" errors so I wanna trash whatever I did and start from scratch, but I don't know what exactly to delete? Does anyone have an idea about this?

Configuring MySQL
I have WindowsXP Proff. O/S. And I have installed mySQL ver 5.0.1
I have also installed php and Apache in it. Now I want to configure it
with Apache, PHP and I also want to configure with phpMyAdmin.
so I can use it comfortabley. So does anyone have an documentation
of it?

Configuring PHP And MySQL
I've installed Apache 2.0.59 [ C:Program FilesApache GroupApache2 ] and PHP 5.1.6 [C:PHP] successfully. I've tried test page also it works. I've also installed MySQL 5.0.24a successfully. But i couldn't connect PHP file with MySQL database. I've searched in google too but not getting please write for me or suggest me the best website which describe the installation process of the version i've mentioned above.

Configuring MYSQL 5.0
I downloaded MYSQL 5.0 and tried to configure it but I do get the message "Could not start service MYSQL : Error :0". if anyone can advice me what do or where to seek information to correct the problem.

Installing And Configuring MySQL
System: MAC 10.3.2 G4 workstation

For the past three weeks I am trying to do the "simple" install. But of course it never works the way it reads. I have followed the FAQ and install descriptions that came with the package <http://www.mysql.com/doc/en/Mac_OS_X_installation.html>
but i am stuck. At the moment I need to create a database and set the root password. i have no idea why it is not working. the following is the command line and error I am getting. Can someone please help me to install this properly?

Configuring MySQL For JDBC ?
I'm having a MySQL DB running on one machine and a Java-Tool which accesses this DB via JDBC. With this tool, I can add a second DB data source in form of a mySQL DB and I've installed one more MySQL DB on a third machine, which runs perfect, but the access from the java-tool via JDBC-connection doesn't work.

Command line "mysql" tool work perfect from the machine where the java tool is running. The company which coded the java-tool told me that I have to install a package for the mysql db which enables jdbc. Is that right and what do I have to configure ?

Configuring/Setting Up MySQL 5
Im a complete newbie to mac os x. I downloaded and installed mySQL 5. I installed it and now i cant seem to connect. I have absolutely no idea what im doing. Im not familiar with os x termial commands. I need someone to email me and explain to me everything i need to do in order to create a user and successfully login using mySQL admin.

I've been struggling with this for over a week. Ready to pull my hair out. And please dont refer me to online resources, ive read them all and still cant figure it out. I need a professional who can give me a step by step process to get this going.

Configuring MySQL With Tomcat
I'm trying to configure Tomcat 4.0.1 with mySQL 1.3. I have copied the mySQL driver (mm.mysql-2.0.8-bin.jar) into tomcat/common/lib but I can't get a connection with the database. I can see the database and tables when I use the GUI for mySQL (winmysqladmin.exe). I'm running Win2K and java 2sdk1.4.1_06.

Configuring MYSQL Enterprise Monitor
I was given the setup files for configuring the MYSQL Enterprise Monitor with dashboard for testing in Local.

1. I have installed MYSQL Server to my localhost [Windows].
MYSQL SERVER Version: 5.0.50sp1a-enterprise-gpl-nt.

2. I have installed the MYSQL Network Monitor to my local system [Windows]
With all options like admin login, agent and other details.

But my doubt is how to set my MYSQL DB Server for regular monitoring using the MYSQL Enterprise Monitor.

I.e I just want to know about the Server setting like how to add my localhost server to the Mysql Enterprise Monitor.

We have a Enterprise Subscription but as iam just a developer i dont have the login id so can i get help from here?

Software Rollout: Configuring Mysql Driver
When rolling out software that uses a mysql backend, how is it possible to configure the odbc driver for mysql during the installation process of the software?

Is there anyway to do this via command line, installshield, batch files..? What would one do if individuals were not "computer literate", and would not how to go about setting up the driver themselves or to make it easier, the software would automatically do it for them?

Configuring MyODBC
I am using MyODBC 3.51 with Borland BDE, and was having a problem whereby Blob result fields were being restricted to a maximum size of 32k. Now, in the BDE control panel, I can set configuration variables for the MyODBC driver, and I was able to change the value of BLOB SIZE from 32 to 128, which solved the problem. However, there are many other configuration variables there (TRACE MODE, BATCH COUNT, BLOBS TO CACHE, ENABLE SCHEMA CACHE, ROWSET SIZE, etc.) for which I have not been able to find any documentation. Does anybody know where I can find documentation for these settings?

Configuring A New Server
while configuring a new server instance the following error message is throwed:

" The template configuration file cannot be found at C:programFilesMySQLMySQL Server 4.1inmy-templates.cnf "

Configuring On Win98
Win98 , Apache 2.0, Apache running on port 443 is that matters.
Latest version (community) of mysql, 5 i think.
Have run the msi file and installed mysql. Wasn't promted for a username / password during this , not sure if thats right, maybe only on win2000/xp?
I'm stuck as what to do next.
cd'ed to mysql....in and ran mysql.exe and gives me the error,
cant connect to mysql server on localhost 10061.

Configuring The Service In Each Start Up?
A couple of weeks ago I posted several questions in one post, and I think I overwhelmed people, so I'm breaking it into individual questions this time.

I don't know why but everytime I use MySQL I need to reconfigure the server using the wizard(I go to start>programs>mysql>MySQL server 4.1>MySQL service instance config wizard) everytime I turn my computer on. If I don't, I get a "ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)" error when trying to connect to the server in any account. I don't have to change anything when I run the wizard, I just click next all the way, and when its done I can connect normally.

I've noticed that at the end of the configuration when its running through all the tasks, the last one says "Sart service". I'm guessing that I'm not starting the mysql service when I turn my computer on, and that reconfiguring the service solves the problem because it starts the service for me. Do I have to reconfigure the service everytime I want to use it? Is there another way or maybe start the service automatically?

Configuring XAMPP In The Domain
I am installing my XAMPP in my pc.

It works fine. Everything works. My question is, is it possible to install XAMPP inside in my domain e.g., www.mydomain.com/xampp. Please help me to configure it using the domain, not in the localhost.

Configuring Database Server
tell me a way to increase the productivity of a database server. It has nothing else installed other than the newest production version of mysql and the default packages from FreeBSD.

Is there a toaster than can bring me up to speed.

Configuring Script For Mbstring And Pconnect
i was told i need to "configure your script to use pconnect (persistent connections) to the mysql database.". because "Your site is creating too many concurrent connections (20 is a reasonable limit).".

as well i need to figure out how to add the mbstring function on mysql, so that my pages with special characters (french characters), will load up properly.

Configuring A Database On A Remote Server
i have an aplication on .net for web, with mysql db, in my local server i have no problems, but recently i upload the aplication into a bougt host; when i open the page on the internet explorer or firefox, the page loads well, except for one simple grid. in another part of the aplication i try to insert a record, the app gave the me no error message, but when i check the table, there's nothing new.

i don't if i configuring something wrone, on the web.config. and the worse of all if that i dont get any error?

New Error 1146 Error And Behavior With Mysqlcc + Mysql-5.0.15
I have just switched from mysql-4.1.14 on a FreeBSD-4.11 box to
mysql-5.0.15 on a FreeBSD-6.0 box. In both environments I use mysqlcc
to select, insert and update tables. On the 4.1.14 machine, using
mysqlcc, I could double click in a field and change its value; only if
I had selected all the fields. I couls not do this if I had selected a
subset of the fields. The number of rows returned didn't matter, as
long as I did "select * from..." I could directly edit a field value in
mysqlcc.

Now, under mysql-5.0.15, I cannot edit fields at all, whether I "select
* from..." or not. And every select I do gives me this error in
mysqlcc's explain pane:

[mymachine] ERROR 1146: Table 'tablename.1' doesn't exist

Well it certainly does exist, and I can edit its values using the mysql
client or phpmyadmin (ugh, clumsy). There are lots of posts on the net
about error 1146 and various apps and various versions of mysql and
even mysqlcc. mysqlcc had this problem with an earlier version of mysql
than 5.x but this supposedly was fixed with release 0.94.

Can anyone give me some insight on what's going on here, or a
workaround? Or another gui client that works as well as mysqlcc?

MySQL Error, #1064 - You Have An Error In Your SQL Syntax.
I was adding a table in phpMyAdmin and when i clicked on go it produced this SQL CREATE

TABLE `pm` (
`to` VARCHAR( 30 ) NOT NULL ,
`from` VARCHAR( 30 ) NOT NULL ,
`message` BLOB( 25000 ) NOT NULL ,
UNIQUE (
`to` ,
`from`
)
)
and this error
MySQL said:

#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 '(25000) NOT NULL, UNIQUE (`to`, `from`))' at line 1

Mysql 1450 Error False Error
how to get more information than this? I am not running out of resources, I have a website written in Perl and than an external Java Server accessing the same database.

It seems that the Java Server is somehow either locking a table or taking more resources than it should. Is there anyway I can adjust the my.ini file to allow more resources to fix this error? Or flick a flag to get more information to what exactly is causing the error?

DEFAULT CHARSET Error (was "Odd MYSQL Error!! :(")
I keep getting this error

PHP

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 31, 2006 at 09:06 PM
-- Server version: 4.1.19
-- PHP Version: 4.3.11
--
-- Database: `jesse_game`
--
-- Table structure for table `games`
--
CREATE TABLE `games` (

`gameid` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`gametitle` text NOT NULL ,
`gamedesc` text NOT NULL ,
`gamekeywords` text NOT NULL ,
`gamefile` text NOT NULL ,
`gameheight` int( 11 ) NOT NULL default Ɔ',
`gamewidth` int( 11 ) NOT NULL default Ɔ',
`category` int( 11 ) NOT NULL default Ɔ',
`timesplayed` int( 11 ) NOT NULL default Ɔ',
`totalvotes` int( 11 ) NOT NULL default Ɔ',
`totalvotepoints` int( 11 ) NOT NULL default Ɔ',
`rating` int( 11 ) NOT NULL default Ɔ',
`gameicon` text NOT NULL ,
`gamestatus` int( 11 ) NOT NULL default Ɔ',
`playedtoday` int( 11 ) NOT NULL default Ɔ',
`gamelocation` int( 11 ) NOT NULL default Ɔ',
`iconlocation` int( 11 ) NOT NULL default Ɔ',
`instructions` text NOT NULL ,
`filetype` int( 11 ) NOT NULL default Ƈ',
`customcode` text NOT NULL ,
PRIMARY KEY ( `gameid` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1515;

MySQL said:

#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1515' at line 23

PHP

#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1515' at line 23

ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem.

I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:

ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL Server Has Gone Away
Hosting Package Environment:
ASP.NET ver 2
MySQL 5.0
FP Extensions 2003

Progression:
Developed Website Outline
Developed Database in Access2003
Migrated AccessDB to MySQL @ Hosting Service using Migration Tool.
Can connect using MySQL Admin tools and run queries fine and all data, relations etc. are there.

PROBLEM: (The heart of the matter)
Starting simple, created GridView Control using Microsoft Visual Web Developer 2005 Express, a few glitches here and there, used the MySQL Connector/ODBC v5.00.11 followed instructions. Can see database in Database Connections Window but when I try to connect the GridView Control to it I get:

"Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online.

ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL server has gone away"

Had thought that "Microsoft Visual Web Developer 2005 Express" might be messing with the ODBC driver so thought to download the .NET Connector. That's when it all went bad. The documentation does not say how to install or use the connector or where to put the files. It seems to assume that these bits of information are common knowledge and I suppose that if I had kept up with the technology it might be. But alas I didn't and it Isn't and It Don't work.

MySQL Error Number 2003 :: Can't Connnect To MySQL Server On 'hostname'(10065)
I was running an older version of the query browser a while back to connect to an older version of mySQL (3.0) running on a linux box. The server hasn't changed, but the query browser has been upgraded to 1.1.10. I can't go back to the older version of the query browser because the machine that ran it got re-formatted so I downloaded the new version and installed it.

So ... I get the following error when I try to connect:

MySQL Error Number 2003
Can't connnect to MySQL server on 'hostname'(10065)

Interestingly, I wrote a simple PHP script to connect to the server and pull some data off of it:

MySQL Error 2013: Lost Connection To MySQL Server During Query
I'm running sugarcrm on mysql and the following query is returning "MySQL error 2013: Lost connection to MySQL server during query":

ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I want to user ports to install phpBB
But I found that phpBB doesn't support mysql 5.x (but the ports
installed mySQL 5.0.0 alpha)

so I deinstall mysql5-server and mysql5-client
And then I install mysql41-server and mysql41-client on FreeBSD 5.3 by
ports but now , mysql is not workable Code:

MySQL-error : Can't Connect To Local Mysql Server Through Socket
On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get
the following problem when connecting to mysql through a browser
(phpMyAdmin)::

#2002 Can't connect to local MySQL server through socket
/var/lib/mysql/mysql.sock

On the website of MySQL this error is mentioned but I found no solution.

In /var/log/messages the following log occurs :
localhost kernel: audit(....): avc: denied {write}for pid=2458
exe=/usr/sbin/httpd name=mysql.sock dev=hda13 ...

What I have tried :

- mysql.sock is srwxrwxrwx, seems ok, but dont know what the s stands for
- the dir /var/lib/mysql was drwxr-xr-x and I changed it to drwxrwxrwx : no
effect
- tried different version of phpMyAdmin : same error
- installed my website and got the following error : No connection possible
with database (in the next version I will improve the error-messages)
- through commandline there is no problem in connecting to mysql (log in,
create databases, inserts, deletes, uploading dumps, making dumps, ....)

What is the solution or what else can I try ?

Error With SQL Statement When Using MySQL 5.0.24 (Works Fine In MySQL 4.0)
Here is my query that worked in mySQL 4.0 but not in MySQL 5.0.24:

INSERT INTO magtallynew SET magempnum=?', magcentre='YVRRC', entrydate=&#55614;&#57158;-08-15', empnum=?', empcentre='YVRRC', connection='Rockwell', service='Express', region='dom', callertype='CSR', otherdept='', transferredcall='No', directrespdept='No', station='Not Applicable', withoutmagassist='Yes', category='Accounting', issue='Advised On Contact', comments='test'

Here is the error message I get:

#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 'connection='Rockwell', service='Express', region='dom', callertype='CSR', otherd' at line 1

Create Table Error. #1064 - You Have An Error In Your SQL Syntax; Check The Manual That Corresponds
I have been trying to create two tables with the SQL below. I have the SQL in file and tried to import it to PhpMysqlAdmin in my control panel. The wierd thing is that the first table gets created while the second one is not created and error is thrown instead. The error message is

#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 ....

ERROR 1010 (HY000): Error Dropping Database (can't Rmdir '.a', Errno: 41)
I am using MySql 5.0.21-community Edition for widows XP. I can successfully connect to the MySql Server as a root and create a database 'a'. Which creates a directory 'a' under my mysqldata directory with a single file 'db.opt'. Now dropping the database 'a' gives the following error

ERROR 1010 (HY000): Error dropping database (can't rmdir '.a', errno: 41)

The directory mysqldataa does not have any other files or hidden files. The commands I have executed are:

------------
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 6 to server version: 5.0.21-community-log

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> create database a;
Query OK, 1 row affected (0.09 sec)

mysql> drop database a;
ERROR 1010 (HY000): Error dropping database (can't rmdir '.a', errno: 41)
mysql>
---------

I have searched web, lists, bugs and could not find any.

Error 1064 Restoring PhpMyAdmin Dump (error On Foreign Key Clause)
I am getting an Error 1064 when I try to restore a dump I created using phpMyAdmin from an online database into a newly created database on my home system.

The error points to a section of the dump file that adds foreign key constraints.

I've already disabled the foreign key checks. The problem seems to occur only with tables in which I have more than one foreign key.

The dump file foreign key constraint section looks very odd to me because multiple ALTER TABLE statements to add foreign keys are separated only by commas, not semi-colons, and even weirder, each time a new statement to add a foreign key constraint is created, it is then repeated in the creation of the next foreign key constraint. Code:

ERROR 1016 (00000):Can't Open File: 'agent.InnoDB'. (error: 1)
i copied database directory from a windows system to my linux system.
i am able to open few files (using select *...) but for other files i get the above error...

I Get This Error Error: Libmysqlclient.so.10: Cannot Open Shared Object File:
I have moced an app from one server to another and I am testinga python module that will extract lead from a database and send them to our email vendor. However, In running the script as a test, I get this error:

Import Error: libmysqlclient.so.10: cannot open shared object file:

What doe sit mean and is there an easy way to fix it?

Got Error 134 From Storage Engine. Error Number 1030
Sometimes when I execute a query on a database, I get the following error from MySQL:
Got error 134 from storage engine. Error number 1030
Does anyone know what this mean?
What does error 1030 mean and can I get other values for error 134?
I heard people saying that this is an indication that a table got corrupted, but I want to hear more about this problem.

Mysqldump, Getting Error Error #1016, Can't Open *.ibd File
So we have a MySQL database that suddenly started reporting "can't
open *.ibd file" errors on InnoDB tables in phpMyAdmin. (MyISAM are
fine). To recover the data is all I want at this point -- so one
suggestion I came across was to try and dump using mysqldump like
this:

mysqldump -u root -p mydatabase databasedump.sql
Enter password: *******************
mysqldump: Got error: 1016: Can't open file: 'access.ibd' (errno: 1)
when using
LOCK TABLES

Is there a way to run this dump so that it will export the database
tables and ignore the *.ibd error? I had read that removing *.frm
files might help, but our testing suggests that it isn't effective
either.

Is This A Mysql Error?
ok, here's my problem, when i run this php page, an error seems to occur with this?

PHP

$sql = "SELECT ID, Rating, DATE_FORMAT(R_Date, '%c/%e/%Y') as date, ASP_Name, Username FROM REVIEW WHERE ASP_Name = $_POST['name'] AND (R_Date BETWEEN $_POST['S_Date'] AND $_POST['E_Date']) ORDER BY R_Date DESC";

http://scasp.com/testing/reviews.php
Thanks
Below is the sql statement run in phpmyadmin

Mysql Error
can anyone tell me what is wrong with this statement :

SELECT GREATEST(fldIncomeMultiples1st,fldIncomeMultiple2nd, fldIncomeMultiplesJoint) AS test FROM table1 WHERE test != "na";

i get 'unknown column test in where clause'. putting it in backticks doesnt help.

mysql version 4.1

MySQL Error ...going From 4.1.14 To 4.1.15
I'm new to the mySQL and have a question for anyone who can help me.
The syntax in question is...

ERROR 1064 at line 19: 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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
HITS int(11) N

And the actual statement is...

CREATE TABLE PLD_CATEGORY (
ID int(11) NOT NULL auto_increment,
TITLE varchar(100) NOT NULL default '',
TITLE_URL varchar(100) default NULL,
DESCRIPTION varchar(255) default NULL,
PARENT_ID int(11) NOT NULL default Ɔ',
`STATUS` int(11) NOT NULL default Ƈ',
DATE_ADDED timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
HITS int(11) NOT NULL default Ɔ',
PRIMARY KEY (ID),
KEY PLD_CATEGORY_TITLE_IDX (TITLE),
KEY PLD_CATEGORY_TITLE_URL_IDX (TITLE_URL),
KEY PLD_CATEGORY_DESCRIPTION_IDX (DESCRIPTION),
KEY PLD_CATEGORY_PARENT_ID_IDX (PARENT_ID),
KEY PLD_CATEGORY_STATUS_IDX (`STATUS`),
KEY PLD_CATEGORY_HITS_IDX (HITS)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=135 ;

The sql file is from version 4.1.14 and the problem is occuring in version 4.1.15

MySQL Error
Why does this code produce an error?

<?
include "connect.php";
$DB = new DB;
$query = "SELECT * FROM sermons ORDER BY name ASC";
$result = mysql_query($query);
$numrows = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){
echo "<tr align='left'>
<td>$row[id]</td>
<td>$row[title]</td>
<td>$row[speaker]</td>
<td>$row[length]</td>
<td>$row[mp3]</td>
<td><a href='edit.php?id=$row[id]'>Edit</a></td>
<td><a href='delete.php?id=$row[id]'>Delete</a></td></tr>";
}
?>

Here is the error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/grace4mi/public_html/sermons/admin/listing.php on line 32

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/grace4mi/public_html/sermons/admin/listing.php on line 33

MySQL PK Error....
I have successfully parsed the dmoz dump files into mysql.
There are 4 tables: structure, content_description, content_links and datatypes.

Structure table has fields: catid, name, title.....
I set the primary key as CATID and it works fine.

When I tried to do the same for the rest of the tables such as datatypes (with fields: catid, type, resource) i always got this error:

SQL query: Edit

ALTER TABLE `datatypes` ADD PRIMARY KEY ( `catid` ) ;

MySQL said: Documentation
#1062 - Duplicate entry Ƈ' for key 1

same goes to other tables (content_links with fields: catid,topic,type, resource).

Another problem, the 3rd table (content_description) has the following fields: externalpage, title, description,ages, mediadate,priority.

the question is which one of these fields should be the PK here?

MySQL 5.0 Error??
I'm trying to follow the tutorial here:

http://www.developertutorials.com/tu...620/page1.html

Whenever I type this:

mysql> CREATE TABLE images (
-> imgid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> sixfourdata LONGTEXT NOT NULL,
-> ;
I get this error:
ERROR 1064 (42000): 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 ''

MYSQL ERROR
I am using MYSQL 4.0.20d and i am trying to install Hostadmin 3.1 on my dedicated server (windows 2003) and the installer can access the database fine beacause it creates all of the tables in the database, the problem is when i try to access it, i already checked that the dbhost,user, and pass are correct...i am also having similar problems with other MYSQL applications....but phpbb2 installed and worked perfect, did nothing diffrent tho...below is the error i am getting

Warning: mysql_pconnect(): Unknown MySQL Server Host 'DB_HOST' (11004) in C:Inetpubvhostsxtreme-design.orghttpdocshostadminadmindb.conf on line 21
Database error: connect(DB_HOST,DB_USER,PASSWORD) failed.
MySQL Error: ()

Mysql Error
iÂ´m trying to pass a database from nucleus 3.2.4 to wordpress 2.1.2 using a script that i found at sourceforge.

It works but when IÂ´m in the third chapter i get this error:

Importing Nucleus items...ERROR: MySQL Error: 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 ')' at line 1SQL query: INSERT INTO `wp_post2cat` (`post_id`, `category_id`) VALUES (3, )

MySQL Error Log
I have installed MySQL on my Win 2K server. Everything seems to be OK, but I get the following error (in MySQL Administrator) everytime I reboot.
CODE[Warning] 'db' entry 'DBNAME USER@localhost' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.