MYSQL :: JNDI Datasource Configuration Fo MySQL 4.1

Coldfusion Mx Connection To Mysql Datasource
I'm trying to add a mysql datasource using the coldfusion administrator. It's not working. I get the following error:

# Connection verification failed for data source: mydatabase
[]java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?

Exporting MySQL Data To External Datasource
I am having trouble looking for ways to export data from mysql database to other sources such as excel, csv, access or mssql. I tried the migration tool kit but it works only 1 way that is importing data only ... and i can't find any option for exporting data.

MySQL Configuration
Does anyone know how to configure mysql dattabase to accept arabic caracters?

Mysql Configuration
On WAMP, how do you configure MySQL? When I had it separately, I was able to set up my own password by doing the configuration, but with WAMP, I'm not sure how to do it, so I can't go into the MySQL console.

Configuration Of MySQL
Everytime I start a new session of MySQL, it prompts me for my password and then boots me out. After I go through the "MySQL Server Instance Config Wizard" and reconfigure everything and reset my password, MySQL lets me back in. Is there anyway to fix it so I don't have to reconfigure everything?

MySQL Configuration
I have recently installed the MySQL5 on my Windows XP. When I try to configure it using the provided configuration wizard, at the last stage "Apply security setting" it gives me the following error:
Quote: The security settings could not be applied.
Error Number 1045.
Access denied for user 'root'@'localhost'(using password:YES)

Problem With MySQL Configuration On IIS With PHP
Everytime I try to read from any MySql database in PHP, I get a blank screen or just a blank response.

I dunno what the problem is. is it the configuration?

When i use phpinfo(), MySql has its own section, which is shown. doesn't this mean it has been configured already?

I have done the configuration of the php.ini file and have removed the quotes before the mysql extensions. I have also included my c:php directory to the path section of my environment variables in control panel and copied libmysql.dll to my windows directory. I just can't seem to get around this problem.

I don't think its my code because i have literally copied code listings from this site and pasted them as trials but still the same thing.

I would appreciate something like a checklist for configuring mysql to work with iis and php to confirm my configuration.

Mysql Configuration File
I just installed a Mysql server version 4.1. I'm trying to set up replication between two servers. The instructions ask me to modify the my.cnf or my.ini file, but there's no such file in my computer.

MySQL Configuration Error
I am trying to get MySQL set up on my Windows server.
The server is running Windows 2003 Server Enterprise Edition and IIS 6.0

I have installed MySQL successfuly but run into problems when configuring it. I get all the way to the Start Server page and click execute.

When I do this I get a tick in the Prepare COnfig and Write Config File boxes but then when it tries to start the server it comes up with the error:
'Could not start the service MySQL' .

MySQL Server Configuration
The server is running Windows 2003 Server Enterprise Edition and IIS 6.0

I have installed MySQL successfuly but run into problems when configuring it. I get all the way to the Start Server page and click execute.
When I do this I get a tick in the Prepare COnfig and Write Config File boxes but then when it tries to start the server it comes up with the error:
'Could not start the service MySQL'

PHP5 MySql 4.1 IIS 5.O Configuration Error.
Finally, I decided to go fully into PHP. I downloaded PHP 5 on the PHP site. I also downloaded MySQL 4.1. I'm running IIS on a WinXP professional (SP2) machine. I installed both according to instructions. Tested PHP, it worked fine. Tested MySQL through command prompt and it also worked fine. Now my problem came when trying to get PHP to use MySQL, I got this error
Warning: PHP Startup: Unable to load dynamic library 'c:/php/ext/php_mysql.dll' - The specified procedure could not be found. in Unknown on line 0
I googled and discovered this situation was common all over the internet. It looks like it's peculiar to PHP5. I tried all solutions I saw but none worked. I copied all the relevant dlls to C/winnt and C/winnt/system32 as well as uncommenting the path variable in PHP.ini Still,

MySQL Slow: Configuration To Blame/fix?
I have MySQL 5 running on a PC, and have grown used to the startling slowness of MySQL joins. The most recent disappointment is a straightforward self-join of a not-too-big (700K rows), indexed (on very-high-cardinality column FILE) table

create table temp2 as
select a.*, b.time as time2,
from temp1 a left join temp1 b
on a.file = b.file
and timestampdiff(HOUR,a.time,b.time) = 1;

that completed in 10 hours. (Indexing resulting table took 20 minutes). If this is not a problem with the programmer, or with MySQL, could it be a result of a mismanaged installation, one that could be fixed with a judicious re-configuration/choice of MySQL options?

Configuration Of MySQL - ORDER BY Clause Problems
Edit:
Solved! Single quotes around the column name were the problem... red herring... didn't spawn an error, probably because single quotes would be valid for an alias?

Anyway, for reference there must be a MySQL setting that tells MySQL to ignore the single quotes in an ORDER BY clause and call the column if there's no matching alias. If anyone knows what *that* setting is, I'm still interested...

I'm stumped! A simple PHP application with a filter using ORDER BY has been moved from a remote server on to a local Debian (Etch) machine running XAMPP. On the remote server it worked fine. On the local server the ORDER BY is ignored. It looks like this:

SELECT *
FROM contacts
WHERE Forenames REGEXP '^{name}'
ORDER BY '{column_name}'
Where {name} is user entered data and {column_name} is determined by which column header in the returned data was clicked in the interface. For example:

SELECT *
FROM contacts
WHERE Forenames REGEXP '^Jake'
ORDER BY 'Company'
As I say, this *was* fine... but now on the local machine the ORDER BY is totally ignored by MySQL. I know the problem is with MySQL because I get the same result in the MySQL Query Analyser, so it's not a PHP/Apache issue.

Is there a config option for switching ORDER BY on/off like there is in MS Access? I'm 99% sure this is a MySQL config problem...

MySQL Server Instance Configuration Installation
Hi everyone. I just tried installing MySQL Community Edition, but it has frozen up during the final step (MySQL Server Instance Configuration). I'm installing it on Windows XP, and I used all the default settings, except that I changed "Detailed Configuration" to "Standard Configuration". The installation window now says "Not Responding" and I don't know what to do. I guess if I shut it down manually, MySQL won't be configured properly. I don't know if this will corrupt the installation, or if the installation part has already finished.

MySQL Server Instance Configuration Wizard
I just downloaded and installed MySQL 5.0 on a P4, Windows XP Pro system and followed the Server Instance Configuration Wizard. Once I have selected the default settings, and clicked Execute, I get an error message

Cannot create Windows service for MySQL. Error: 0

MySQL 4.0.18 InnoDB Configuration Issues On SuSE 9.1 Pro
I've tried resolving this issue in a SuSE newsgroup, but after trying
their suggestions and working on this issue for far too long already, I
decided to try this list as it may be a more appropriate discussion area.

I've installed and configured MySQL 4.0.18 on a SuSE 9.1 system using
the default RPM's that came with the distribution.

I created a simple database (one table with InnoDB engine type) and have
tried running some ODBC source against it to test transactions, but I
get the error that the server does not have transactions enabled.

I was directed to enable transactions in the configuration file
(/etc/my.cnf) by uncommenting the lines for innoDb use. However, after
uncommenting these lines and running mysqld from the commandline
(according the online Manual), to generate InnoDB support tables, I get
the following error:

mysqld: ERROR: unknown variable 'innodb_data_home_dir=/var/lib/mysql/'

I've tried removing the RPM's and starting from scratch, but cannot get
past this error and successfully test transactions in my unit tests.

MySQL Entry Level Server Hardware Configuration
We have a web site statistics database running on a dedicated PC (P4 1GB RAM, 1xSATA, Windows Xp 32 bit). It's updated daily and used by a single user to get some reports. While it's mostly SELECTs, some temporary tables can be built.

As the database get bigger and bigger (few gigabytes), it works slower and slower. Currently the HDD is the bottleneck, but the PC is not upgradeable, so I'll have to build a new server. Reliability is NOT #1 in my list, while the speed is - it'd be easier (and chipper) for me to copy the data across rather than to build a 4+ dsik monsters.

What would be the suggestions for hardware and OS? Or may be a URL to detailed review?

What Will Be The Best My.cnf Configuration?
I have a MySQL 5.0.27-standard-log slave server running on a server with

Processor: Dual Xeon E5372 Quad Core (Clovertown)
RAM 12GB
Hd1: 120GB
OS: Linux - CentOS 4

I have 15GB+ data with MyISAM and InnoDB tables. InnoDB tables are not in much use, we perform user searches on MyISAM tables which have FULLTEXT.

Question: What will be the best my.cnf configuration? Below is the current my.cnf ....

Configuration
I'm learning Java and Databases..I need help.

I don't know about databases, but I have to use one... I chose a MySql for use...
How can I configure a MySql Control Center (GUI) or Where I find a tutorial that show me this configuration?

DSN Configuration
I have Groupmail running on a remote machine with a fixed IP and want to set up a database connection from my Server.

I have set up a user but am getting the following error:
Access denied for user 'odbcuser'@host<IP> (using password: yes)
where odbcuser is the user and IP is my remote machine's IP

Configuration
I've downloaded MySQL community server, the one without the installer, and I've unzipped it into c:.

I need to configure it to work locally, only in this computer. No internet connection.
Can someone give a clue.I know nothing about server configuration, neither databases. It's to run a weblog server application in this computer.

Help With Configuration Error Please.
I'm trying to install MySQL 2.0.5.5 on Windows XP Home Edition SP2. Once I get to the configuration wizard stage, and I press execute, it gives me:

Quote:

Could not start the service MySQL. Error: 0

I've spent a very long time searching Google, forums, Usenet etc. for answers to this query. Lots of people have experienced it, and there don't seem to be any working solutions out there.

I've done the following (to no avail):
- Removed the service (using "sc remove mysql" at the command line).
- Tried different service names.
- Opened the port MySQL wants to use.
- Changed the port to another open port.
- Disabled my firewall.
- Tried starting MySQL from the command line.
- Tried different versions of MySQL.
- Tried rebooting the PC and all the usual stuff.

None of it works, I continually get that error. Can anybody offer a working solution to this problem? I would appreciate it very much. Or offer a better/equal alternative to MySQL that can be easily integrated with PHP.

Instance Configuration
I have Windows 2000 and when i execute the instance configuration wizard i get this message once it reaches the write configuration file:
Configuration file template C:Program FilesMySQLMySQL Server 5.0my-template.ini could not be processed and written to C:Program FilesMySQLMySQL Server 5.0my.ini.Error code -1.
what must i do to continue my instalation?

SQL Configuration Problems
I am trying to set up an independent demo system using 2 laptops (client and server) of a system that I have developed and part of that system is a PHP/MySQL web interface which I want to run from the server laptop.

I want the code on the demo system to be exactly the same as the live system (for obvious reasons) but there is something in the configuration of MySQL on the demo system which is causing one of my queries to fail. As I am not used to configuring MySQL I would appreciate your advice.

Error is:
Incorrect date value: '' for column 'birthdate' at row 1
SQL was:
INSERT INTO users (username, user_password, title, firstname, surname, email, birthdate) VALUES ('Test', 'password', '', '', '', 'test@mydomain.com', '')

The database is just a dump of the live database so all tables/fields are same types but the live system doesnt complain if birthdate is left empty.

Can anyone advise as to which configuration setting is causing this difference.

Configuration Of New Database
I zipped up my website from one server and would like to move it to another
hosting company. Where in the tree are the configuration files for SQL
kept? I see a file called database which is a text document but I do not
see the password for the SQL configuration. This all runs under Linux /
Apache / MySQL.

Configuration Problems?
I've recetly installed MySQL on my Windows 2003 server to use for a few websites im building. I went through the installation for 4.1.8-nt and everything seemed to work fine. I created a couple of databases and played about a bit to get used to things, everything seems to work fine.

Now im trying to install a phpbb forum onto my website but when i get to the installation process and fill in all the details its comming up saying "The PHP configuration on your server doesn't support the database type that you chose". Now im pretty sure the configuration is correct and no matter what I try im getting the same reply.

Specifying INNODB Without Configuration
Is it a bug or a feature that with the conditions

1. INNODB is not configured in my.cnf
2. Table type is specified as INNODB

that when you create the table there is no warning,
and no syntax error, and the table type silently
and Microsoft-like, defaults to MyISAM?

Now, if you specify table type as TYPE=bullshit,
you get a nice (and expected) syntax error.

Privilege Configuration
a user that is not quite normal and not quite root. Specifically, I am looking for a setup that would allow this user to create/delete and grant lower "normal" users access to databases for learning. However, I do not want this user to have the ability to do anything to the main mysql database containing user information.

Vista Configuration
I am getting the following message when I click on MySQL Server Instance Config Wizard:

This file does not have a program associated with it for performing this action.
Create an association in the Set Associations control panel.

Error During Configuration
During the start up configuration I got an error that said: Could not start service MySQL.Error:0

Configuration File (my.cnf)
i have installed mysql 5.0.16 on suse 10.0 x64.

my server works without any problem but i can not find mysql configuration file (/etc/my.cnf).

i have serached my computer all follders but there is not a file named my.cnf.

SQLGUI Configuration
I don't know what to write on the host name(localhost is what I have) but I think am suppose to use an address.

Configuration Wizard
I can't seem to find my earlier post about my problem, so I'll post this
here. I got the following error (with an 'x' in the 'Apply security
settings' part on the final step of the wizard). Hopefully someone knows
how to fix this:
The security settings could not be applied.
Error number 1045.
Access denied for user 'root'@'localhost' (using password: YES)

FULLTEXT Configuration
I'm currently using the FULLTEXT feature of MySQL to perform faster searches in a table. However, I have noticed that it doesn't index (or consider) words of three characters or less. There are many cases where I actually need to search for words of three characters exactly.Is there a way to modify this configuration in MySQL?
The MySQL server is running on a FreeBSD box with Plesk 7.5.

Insufficient Configuration
I was looking through my Apache2 logs and found many entries:
insufficient configuration info to establish database link
child spawned but unable to open database link
Is this something to be concerned about and if so how to fix it. The database appears to operating normally. I ggogled this and found:
At a minimum, LogSQLLoginInfo in the URl form and either LogSQLTableName or LogSQLMassVirtualHosting must be defined in order for the module to be able to establish a database link. If these are not defined or are incomplete you will receive this error message.

System Configuration
I'm currently rebuilding my home system - a couple of linux boxes with Debian.
Although I don't have a high load on any of my systems, I am going to set up a separate box with my mail server and another for my web services. I'm wondering if there is an arguement for or against putting MySQL over on the mail box or even putting it on its own box?Assuming the arguement is for putting MySQL on a different box, are there any pitfalls, tips, tricks I should consider before starting this project?

Server Configuration
I am placing this in the MySQL forum because the apps I run are very MySQL intensive...
I have a number of sites running on a dedicated server. Most of these sites run apps built using PHP and MySQL. We have been getting lately very bad performance on our server, especially related to MySQL. One issue is that we need to focus a lot of attention on optomization of our SQL quieries, but we are planning a server upgrade.
Now my question is not only for the MySQL experts, but focused on them, what is the best setup for running application intensive sites.
Is it a server with powerful processing and memory such like dual Xeon and 2GB memory or is there another configuration like two servers? What are the idealistic and realistic setups that are available?

Apache Configuration
I was just wondering if anyone could help me to configure my home
machine to run as a test server for PHP using MySQL and Apache. I am
running WinXP pro and I would really appreciate some help. (I'm trying
to learn PHP before paying the moola for a host, only to make a fool
of myself while trying to learn PHP. I don't see any logic in paying
for time to learn, when I could do it for free at home and then pay
for a host...) I would be very thankful if you would imagine that I
had just downloaded the files from their appropriate sites, and
haven't even opened them yet. A walkthrough of the installation etc...
The main part I've been having trouble with is editing the httpd.conf
file for Apache;)

Reinstallation Configuration Problem
I have recently encountered a problem with Msql. I loaded it along with PHP5 and the Apache server and all went well for about a month. But I started having problems with Mysql not accepting my password then I had trouble starting and stooping it from the command prompt. So I downloaded the windows essentials version again and reinstalled it. But as I go through the configuration process at the final stage I get two blue ticks for the Prepare Configuration and Write Configuration File but I get a red cross on the Start service and a message â€˜The service could not be started. Error: 0â€™ and the only thing to do is to go back or cancel. If I go to the command prompt and try to start Mysql manually I get an error code 1067 which is understandable.

If I uncheck the â€˜enable TCP/IP boxâ€™ in the networking options stage of the configuration process I get 3 blue ticks Mysql starts and works faultlessly. The only problem is that PHP cannot connect to it because the â€˜enable TCP/IP boxâ€™ was unchecked in the configuration process.

So I now find myself in a situation that I cannot configure Mysql correctly but I have to do, so that PHP will connect.

There is also a database called information_schema on mysql I don't think it was there the first time I loaded it.

Huge Server Configuration
I have a server like 8way Intel Pentium 4 Xeon processor with 12GB RAM and 1TB harddisk space. All the tables size are over 10GB and they have over 100mm records.

Could some one help me get an appropriate mysql configuration(my.conf)file for the machine.

I understand ther are lots of factors depends on it to get a steady working configuration. All I need is some model configuration. I think later on I can tune thar up.

Error: 0 Configuration Wizard
After installing the configuration wizard,I hit the execute button, but when I reach "created windows service" I get a red X and it returns "Error:0"

Sample Configuration File
I am using MySQL for my web server running PHP, Joomla and Gallery 2.
However I am sometimes disappointed with the performance and my test results seem to indicate that most problems are caused by my slow data base. Basically I simply installed MySQL and then I never optimized any settings.

Is there a good guide to do so? Does anybody have a sample configuration file to share? I am basically looking for optimized settings for 512MB (of my 2GB).

Configuration And Usage Of The Relation Feature
im just creating a new database for a browser roleplaying game. Maybe you can imagine how complex this can be sometimes. And while i was working on it i remembered a feature of the MS access database. At access you could create relations for various tables, so if u change a field in one table, it is changed for all fields related/linked to it.

Is there a similar feature in mysql, and if yes, is it the "linked_tables" feature?

AUTO_INCREMENT - Configuration For Replication With Dual Masters
I'm looking at setting up two mysql servers in replication with both
being masters. The most obvious snag in this scenario is
auto_increment, as disconnections between servers could allow user
interaction to generate duplicate keys.

In a moment of zen I thought, "What if one server dealt only in even
numbers, and the other only in odd numbers?" This solution would keep
things simple and manageable, while also keeping the servers off
eachothers' toes.

Has anyone ever tried this? Is it even possible? if not, is there a
similar solution allowing for the same kind of integration?

Going further, I wonder if it's possible to do the same thing with
three or more servers, giving each an algorythm to generate a series
of auto_increment numbers that doesnt collide with the other master
servers in the chain.

Server Instance Configuration Wizard Error
I've installed it but when I run the Server Instance Configuration Wizard, the following error msg pops-up when I click execute:
The security settings could not be applied to the database because the connection failed with the following error: Err Nr. 1142 DELETE command denied to user 'root'@'localhost' for table 'user'

InnoDB Binary Logs - Unique To Each Database Configuration
I would like to back-up our InnoDB databases using a combination of mysqldump and the binary logs. We have multiple databases within our server instance, and each database is unique to a customer so we don't want to mix their data. I know how to create / schedule unique dump files for each database, but was wondering how to configure unique binary logs. Right now all transactions are logged in the same set of files.

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: