2 questions
Hi, I have used mysqldump with 5.0.15-nt and I have seen that it saves the file in UTF-8 format. This is OK, but if I try to run: mysql database saved_file.sql It gives an error near some special chars (because the file is not ANSI). If I convert the file as ANSI, I can import the data from it into MySQL without problems. Am I doing something wrong? The second question is related to explain. Is there a explain function for update as there is for select? Thank you. Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange behavior with integer unsigned type...
mysql 5.0.15-standard UPDATE table SET fieldname = fieldname-1 when the fieldname is 0 gives me 4294967295 fieldname is integer(10) unsigned... maybe it would be more logical the expression to evaluate as 0, insted 2^32 .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL query question
I have several tables, all with many-to-many joining tables. users users_teams teams teams_projects projects --- So, with a projects.id = 1, I want to get all the usernames of people on teams assigned to that project. SELECT DISTINCT username FROM users, users_teams, teams, projects_teams, projects WHERE projects.id = '1' AND projects_teams.project_id = projects.id AND teams.id = projects_teams.team_id AND users_teams.user_id = users.id gives me ALL the users who are on any team... even teams not assigned to that project. What gives? My brain hurts. Thanks for any help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: MySQL query question
Oops, I meant to copy the mailing list on this reply. Rhino - Original Message - From: Rhino [EMAIL PROTECTED] To: Josh Mellicker [EMAIL PROTECTED] Sent: Saturday, December 24, 2005 9:24 AM Subject: Re: MySQL query question - Original Message - From: Josh Mellicker [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, December 24, 2005 5:23 AM Subject: MySQL query question I have several tables, all with many-to-many joining tables. users users_teams teams teams_projects projects --- So, with a projects.id = 1, I want to get all the usernames of people on teams assigned to that project. SELECT DISTINCT username FROM users, users_teams, teams, projects_teams, projects WHERE projects.id = '1' AND projects_teams.project_id = projects.id AND teams.id = projects_teams.team_id AND users_teams.user_id = users.id gives me ALL the users who are on any team... even teams not assigned to that project. What gives? My brain hurts. Thanks for any help. I'm a bit confused by the wording of your question, especially the first sentence: it seems to be implying that you have actually implemented direct many-to-many relationships in your database. That is a very rare thing if you've done it. Normally, each many-to-many relationship is broken down into two one-to-many relationships with another table, called an association table or intersection table, between them. Have a look at this item - http://lists.mysql.com/mysql/176918 - from the archives where I explained how this works several months ago. After my remarks about splitting names into first and last name columns, you'll find a discussion of how a many-to-many relationship is normally implemented in a relational database. Now, having said that, your table names suggest that you are already aware of the normal practice of creating association tables and simply described it strangely. That is why I'm confused: I don't know what you've actually done. This is compounded by the fact that you haven't supplied layouts of the table. I find that knowing the names, primary keys and foreign keys of each table and the full definition of each column in each table help a great deal in verifying that the table is correctly designed. I also find it very useful to see a few sample rows of each table so that I can visualize the data better. But you haven't done any of that so I have to operate blind. I'm going to guess that your remark about many-to-many joining tables simply means association tables and that you simply forgot the correct terms. I'm also going to assume that you've designed your tables correctly. I'm having trouble visualizing it properly since I'm not sure how users would ever be directly associated with teams - I would have expected to find players to be associated with teams - so forgive me if this doesn't resemble very much what you're doing: Users (PK=Userid) === Userid LastNameFirstName --- 1Jones Fred 2Smith Mary Teams (PK=TeamName) TeamNameTeamCity ---- Orioles Baltimore CardinalsSt. Louis Projects (PK=ProjectNo) = ProjectNoProjectDescription ---- A Build new stadium B Raise money for charity Users_Teams (PK=TeamName, Userid) (FKs: User_Teams.TeamName-Teams.TeamName; UserTeams.Userid-Users.Userid) = TeamName Userid - --- Orioles2 Cardinals1 Teams_Projects (PK=TeamName, ProjectNo) (FKs: Teams_Projects.TeamName-Teams.TeamName; Teams_Projects.ProjectNo-Projects.ProjectNo) = TeamNameProjectNo ---- CardinalsA OriolesB OriolesA Now, if you want to join all of these five tables together you will need _at least_ FOUR different joining conditions if you want to avoid getting duplicate or inappropriate rows. Remember, whenever you join N different tables together, you always need at least (N-1) different joining conditions. This is probably why your query isn't working (assuming I am even somewhat close to how your data is structured): you only have THREE joining conditions. With this data, I would do the joins as follows: Users-Users_Teams; Users_Teams-Teams; Projects-Teams_Projects; Teams_Projects-Teams The query would end up looking something like this: SELECT distinct u.LastName FROM users u JOIN users_teams ut on u.Userid = ut.Userid JOIN teams t on ut.TeamName = t.TeamName JOIN teams_projects tp on t.TeamName = tp.TeamName JOIN projects p on tp.ProjectNo = p.ProjectNo WHERE p.ProjectNo = 'A'; or, if you absolutely insist on the old-style syntax, like this: SELECT distinct u.LastName FROM users u, users_teams ut, teams t, teams_projects tp, projects p WHERE p.ProjectNo = 'A' AND u.Userid = ut.Userid AND ut.TeamName
Re: MySQL query question
since I'm not sure how users would ever be directly associated with teams - I would have expected to find players to be associated with teams - so forgive me if this doesn't resemble very much what you're doing: Think corporate projects, not sports. Here's my take on the original query.. you don't actually need to use the teams table in the query, as long as you have DISTINCT in the Select: SELECT DISTINCT username FROM users u, users_teams ut, projects_teams pt , projects p WHERE p.project_id = '1' AND pt.project_id = p.project_id AND ut.team_id = pt.team_id AND u.user_id = ut.user_id Also, just a style comment, I would find it confusing just to use id as the key in the projects, team, and user tables.. and user_id, team_id, and project_id in the associative tables... the field names should be consistent throughout, so when reading queries, it's obvious which id one is talking about. On 12/24/05, Josh Mellicker [EMAIL PROTECTED] wrote: I have several tables, all with many-to-many joining tables. users users_teams teams teams_projects projects --- So, with a projects.id = 1, I want to get all the usernames of people on teams assigned to that project. SELECT DISTINCT username FROM users, users_teams, teams, projects_teams, projects WHERE projects.id = '1' AND projects_teams.project_id = projects.id AND teams.id = projects_teams.team_id AND users_teams.user_id = users.id gives me ALL the users who are on any team... even teams not assigned to that project. What gives? My brain hurts. Thanks for any help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- -Hank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL query question
Josh, I have several tables, all with many-to-many joining tables. users users_teams teams teams_projects projects Once again explicit join syntax clarifies matters: SELECT DISTINCT username FROM users INNER JOIN users_teams ON (users.id = users_teams.user_id) INNER JOIN teams ON (...you didn't mention these keys...) INNER JOIN projects_teams ON (teams.id = projects_teams.team_id) INNER JOIN projects ON (projects_teams.project_id = projects.id) WHERE projects.id = 1; PB - Josh Mellicker wrote: I have several tables, all with many-to-many joining tables. users users_teams teams teams_projects projects --- So, with a projects.id = 1, I want to get all the usernames of people on teams assigned to that project. SELECT DISTINCT username FROM users, users_teams, teams, projects_teams, projects WHERE projects.id = '1' AND projects_teams.project_id = projects.id AND teams.id = projects_teams.team_id AND users_teams.user_id = users.id gives me ALL the users who are on any team... even teams not assigned to that project. What gives? My brain hurts. Thanks for any help. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.7/214 - Release Date: 12/23/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
NOT NULL and default: using mysqldump to upgrade from 4.0 to 5.0
Hi, I have two servers and am trying to move the database from one to the other. The data is currently residing in a MySQL 4.0 database. The new server is running MySQL 5.0. Trying to import a table such as CREATE DATABASE /*!32312 IF NOT EXISTS*/ db17058c; USE db17058c; DROP TABLE IF EXISTS adidas; CREATE TABLE adidas ( manufacturer char(1) NOT NULL default '', brand char(1) NOT NULL default '', product varchar(100) NOT NULL default '', short text NOT NULL, long text NOT NULL, id int(11) NOT NULL default '0', image varchar(124) NOT NULL default '', link mediumtext NOT NULL, buylink varchar(124) NOT NULL default '', track varchar(124) NOT NULL default '', and so on... Throws all sorts of errors, for example 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 'long text NOT NULL, id int(11) NOT NULL default '0', image varchar(124) NOT ' at line 6 If I remove this line then another line a few lines along hits a problem. This appears to be some sort of conflict between NOT NULL and default values; I would be very grateful if someone could confirm what the issue is and suggest a way of solving it (the dump is 500mb, so any manual fix is not a lot of use!) With many thanks, Alex Davies
I'm new to mySQL
Hi, I am new to mySQL and have mac OS X. Please could any other Mac users or anyone for that matter tell me the best way of connecting to a mySQL database? Should I use terminal or a program like PHPmyAdmin? Cheers, James _ Are you using the latest version of MSN Messenger? Download MSN Messenger 7.5 today! http://messenger.msn.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: I'm new to mySQL
MySQL AB has a very good GUI tools Have a look in: http://www.mysql.com/products/tools/ You should try to use them, phpmyadmin also is good. For administration mysql-administrator To execute queries or create functions, procedures, etc mysql-querybrowser To migrate data from another RMDBS so use mysql-mitration-toolkit Those tools work on MAC Regards! Edwin. -Mensaje original- De: James Lumb [mailto:[EMAIL PROTECTED] Enviado el: Sábado, 24 de Diciembre de 2005 02:06 p.m. Para: mysql@lists.mysql.com Asunto: I'm new to mySQL Hi, I am new to mySQL and have mac OS X. Please could any other Mac users or anyone for that matter tell me the best way of connecting to a mySQL database? Should I use terminal or a program like PHPmyAdmin? Cheers, James _ Are you using the latest version of MSN Messenger? Download MSN Messenger 7.5 today! http://messenger.msn.co.uk -- 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: New to MySQL
On Saturday 24 December 2005 1:05 pm, James Lumb wrote: Hi, I am new to mySQL and have mac OS X. Please could any other Mac users or anyone for that matter tell me the best way of connecting to a mySQL database? Should I use terminal or a program like PHPmyAdmin? Cheers, James James, This is just coming from a person who's used MySQL from the commandline, phpMyAdmin, and even from OpenOffice. There's no one right way to access MySQL. Generally speaking, I use the command line for a multiple correction, i.e. if I have to fix a syntax difference on a non-normalized table, or for testing. I use phpMyAdmin for administration purposes (new users and so forth), and OpenOffice for actual data entry. You'll find that is the beauty of MySQL. There are hundreds of ways to access data, and each one has its ups and downs. -- This e-mail is virii free, it has been sent from a computer running Linux. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I'm new to mySQL
On Saturday 24 December 2005 1:05 pm, James Lumb wrote: Hi, I am new to mySQL and have mac OS X. Please could any other Mac users or anyone for that matter tell me the best way of connecting to a mySQL database? Should I use terminal or a program like PHPmyAdmin? Cheers, James James, This is just coming from a person who's used MySQL from the commandline, phpMyAdmin, and even from OpenOffice. There's no one right way to access MySQL. Generally speaking, I use the command line for a multiple correction, i.e. if I have to fix a syntax difference on a non-normalized table, or for testing. I use phpMyAdmin for administration purposes (new users and so forth), and OpenOffice for actual data entry. You'll find that is the beauty of MySQL. There are hundreds of ways to access data, and each one has its ups and downs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I'm new to mySQL
On Saturday 24 December 2005 1:05 pm, James Lumb wrote: Hi, I am new to mySQL and have mac OS X. Please could any other Mac users or anyone for that matter tell me the best way of connecting to a mySQL database? Should I use terminal or a program like PHPmyAdmin? Cheers, James James, This is just coming from a person who's used MySQL from the commandline, phpMyAdmin, and even from OpenOffice. There's no one right way to access MySQL. Generally speaking, I use the command line for a multiple correction, i.e. if I have to fix a syntax difference on a non-normalized table, or for testing. I use phpMyAdmin for administration purposes (new users and so forth), and OpenOffice for actual data entry. You'll find that is the beauty of MySQL. There are hundreds of ways to access data, and each one has its ups and downs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 2 questions
Hello. It gives an error near some special chars (because the file is not ANSI). Please, could you provide the error message. Check if it disappears if you perform the dump with --quote-names option. The second question is related to explain. Is there a explain function for update as there is for select? An update statement is optimized like a SELECT query with the additional overhead of a write. So you can take the optimizer plan from the corresponding SELECT statement (with the same WHERE clause and table references). Octavian Rasnita wrote: Hi, I have used mysqldump with 5.0.15-nt and I have seen that it saves the file in UTF-8 format. This is OK, but if I try to run: mysql database saved_file.sql It gives an error near some special chars (because the file is not ANSI). If I convert the file as ANSI, I can import the data from it into MySQL without problems. Am I doing something wrong? The second question is related to explain. Is there a explain function for update as there is for select? Thank you. Teddy -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: NOT NULL and default: using mysqldump to upgrade from 4.0 to 5.0
Hello. The error should disappear if you perform the dump using --quote-names option. Alex Davies [EMAIL PROTECTED] wrote: Hi, I have two servers and am trying to move the database from one to the other. The data is currently residing in a MySQL 4.0 database. The new server is running MySQL 5.0. Trying to import a table such as CREATE DATABASE /*!32312 IF NOT EXISTS*/ db17058c; USE db17058c; DROP TABLE IF EXISTS adidas; CREATE TABLE adidas ( manufacturer char(1) NOT NULL default '', brand char(1) NOT NULL default '', product varchar(100) NOT NULL default '', short text NOT NULL, long text NOT NULL, id int(11) NOT NULL default '0', image varchar(124) NOT NULL default '', link mediumtext NOT NULL, buylink varchar(124) NOT NULL default '', track varchar(124) NOT NULL default '', and so on... Throws all sorts of errors, for example 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 'long text NOT NULL, id int(11) NOT NULL default '0', image varchar(124) NOT ' at line 6 If I remove this line then another line a few lines along hits a problem. This appears to be some sort of conflict between NOT NULL and default values; I would be very grateful if someone could confirm what the issue is and suggest a way of solving it (the dump is 500mb, so any manual fix is not a lot of use!) With many thanks, Alex Davies -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 2 questions
Hi, Here is the error: mysql -u odbc database zzz.sql ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL serv er version for the right syntax to use near '´¬¬ /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1 But I have discovered that this happends only if I re-save the .sql file with TextPad. After saving the file, even without modifying it, the file size decreases with 3 bytes, and I think TextPad saves the file but without the byte order mark for UTF-8. So MySQL might think that the file is ANSI, and detect some bad chars. Teddy - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, December 24, 2005 23:47 PM Subject: Re: 2 questions Hello. It gives an error near some special chars (because the file is not ANSI). Please, could you provide the error message. Check if it disappears if you perform the dump with --quote-names option. The second question is related to explain. Is there a explain function for update as there is for select? An update statement is optimized like a SELECT query with the additional overhead of a write. So you can take the optimizer plan from the corresponding SELECT statement (with the same WHERE clause and table references). Octavian Rasnita wrote: Hi, I have used mysqldump with 5.0.15-nt and I have seen that it saves the file in UTF-8 format. This is OK, but if I try to run: mysql database saved_file.sql It gives an error near some special chars (because the file is not ANSI). If I convert the file as ANSI, I can import the data from it into MySQL without problems. Am I doing something wrong? The second question is related to explain. Is there a explain function for update as there is for select? Thank you. Teddy -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- 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]
Error message on starting MySQL Server
Hi All New to MySQL in that I have never ran a database. I have Mandrake 10.1 in which I can not connect to because I do not have the correct MySQL connector but MySQL server is working. Having spent over a week looking for the correct connector twice -last August and last week - I am well aware my chance of finding the correct program is not high. So since I have a number of equivalent computers that I can use for test computers I promptly downloads SuSE 10.0 and installed it on one. In the Mandrake box at the root command line and at the user command line I can enter the command 'mysql' and promptly MySQL starts. In the SuSE 10.0 and SuSE 9.2 box [which I also have] when I type the command mysql I get the error message 'Access Denied Can Not Connect to the MySQL Server - Error 202'. I have received the identical error message in the Mandrake box in the past but only when MySQL Server was not installed and I only had MySQL Client installed. I then tried to access MySQL by mysqladmin show and received an identical error message that I am unable to connect. I have reviewed the connection information on the MySQL Connection page and I have additionally tried the following logged into the computer as root: mysql -uroot mysql -uroot -proot password with identical negative results. Identical attempts were tried on both the 9.2 and 10.0 SuSE systems immediate after system installation so there is no possibility of system corruption or of system modification from initial setup. Any assistance as to how to start or access MySQL on the SuSE systems would be appreciates as like I stated above there is NO possibility of MY beingable to access MySQL by OpenOffice in Mandrake 10.1 due to a Connection issue that is well above my ability to resolve. Thanks SOTL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error message on starting MySQL Server
SOTL [EMAIL PROTECTED] wrote on 12/24/2005 06:22:25 PM: Hi All New to MySQL in that I have never ran a database. I have Mandrake 10.1 in which I can not connect to because I do not have the correct MySQL connector but MySQL server is working. Having spent over a week looking for the correct connector twice -last August and last week - I am well aware my chance of finding the correct program is not high. So since I have a number of equivalent computers that I can use for test computers I promptly downloads SuSE 10.0 and installed it on one. In the Mandrake box at the root command line and at the user command line I can enter the command 'mysql' and promptly MySQL starts. In the SuSE 10.0 and SuSE 9.2 box [which I also have] when I type the command mysql I get the error message 'Access Denied Can Not Connect to the MySQL Server - Error 202'. I have received the identical error message in the Mandrake box in the past but only when MySQL Server was not installed and I only had MySQL Client installed. I then tried to access MySQL by mysqladmin show and received an identical error message that I am unable to connect. I have reviewed the connection information on the MySQL Connection page and I have additionally tried the following logged into the computer as root: mysql -uroot mysql -uroot -proot password with identical negative results. Identical attempts were tried on both the 9.2 and 10.0 SuSE systems immediate after system installation so there is no possibility of system corruption or of system modification from initial setup. Any assistance as to how to start or access MySQL on the SuSE systems would be appreciates as like I stated above there is NO possibility of MY beingable to access MySQL by OpenOffice in Mandrake 10.1 due to a Connection issue that is well above my ability to resolve. Thanks SOTL Two things you have to understand: 1) MySQL is a database management system. It needs at least two programs running at the same time to operate. The most important half of this operation is called the server and it actually reads and writes data to the hard drives and responds to various commands sent to it by any variant of the second half the client. The client is any program (one you write or one that is already written) that communicates with the server to make various commands or requests. 2) each client must authenticate with the mysql server. That means that there is another layer of security that is independent from your operating system. You can login to your operating system under any account you wish but unless your mysql client can login to the mysql server with a recognized account, you won't be able permitted to interact with that server. Let's break down your errors as you describe them: I have Mandrake 10.1 in which I can not connect to because I do not have the correct MySQL connector but MySQL server is working. Having spent over a week looking for the correct connector twice -last August and last week - I am well aware my chance of finding the correct program is not high. I do not quite understand what you mean by connector. I think you are looking for a way to interact with the server. MySQL is prepackaged with a command line interface that will allow you to run various commands against the server. I see from your other errors that you have found it already mysql. This is the command line interface (a client) that comes with the mysql server. In the Mandrake box at the root command line and at the user command line I can enter the command 'mysql' and promptly MySQL starts. Not exactly correct. Your client starts and makes a connection to the server running on that machine. Who you connected as depends on which options you list and how your configuration file is written. Since you are new, you probably NOT followed the instructions in the manual on how to setup or test an installation and you have probably not setup a configuration file. That means that you will be connected as the user [EMAIL PROTECTED], a default account that you normally get rid of right away. If I were you, I would review the documentation and compare the steps you have performed with the recommended methods of installing MySQL and testing an installation. http://dev.mysql.com/doc/refman/4.1/en/installing.html In the SuSE 10.0 and SuSE 9.2 box [which I also have] when I type the command mysql I get the error message 'Access Denied Can Not Connect to the MySQL Server - Error 202'. You can also get this message if the server component is not running (even if it is installed, that does not guarantee that it is running). Try following the troubleshooting suggestions located here: http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html I do not know SuSE or Mandrake at all (I am unlucky enough to work in a Windows-only environment) so I cannot