MYSQL :: PHP5 MySql 4.1 IIS 5.O Configuration Error.

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

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.

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

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"

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'

MySQL 4.x And 5.x And PHP5
I've been looking at the upcoming PHP5 with some excitement -- well,
until tonight. It seems support for MySQL in PHP5 will be dropped, or
that is to say; support for MySQL 4 and later will be dropped.

The reasons have to do with the new MySQL AB Licensing -- which I've
looked at and personally don't see a conflict.

Does anyone know the deal with this???

PHP 4 is great, and it looks like PHP 5 will be even better -- however
I don't separate PHP and MySQL -- MySQL is a brilliant SQL engine and
I'd rather switch to J2EE, .NET or ColdFusion MX 6.1 (w/J2EE under
belly) before I lose compatibility with MySQL... After all, what good
is a scripting lang if it ain't got a good SQL eng ??

MySQL 4.1 And PHP5
For my latest project I'm using mysql4.1 and PHP5, so i've decided to use the mysqli function set, I've also recently learned that prepared queries are much better than concatenating SQL strings with the variables inserted.

There are a couple of things I don't fully understand about stmt functons such binding the results. This function presents me with a bit of a problem as I normally use my own objects for db connection and results handling.

mysqli_stmt_bind_result($stmt, $name, $code);

Does anyone know if I HAVE to use the bind_result function or can you use the mysqli_fetch_assoc function? and If not does anyone know how to add the variables dynamically?

PHP5 And MySQL Support
I am trying to compile apache2 with PHP5 with MySQL support. I run the configure command and everything run OK. I then run make then make install and i get no errors. However when i go to look at the phpinfo page -- with-mysql is not in the configure command and mysql sites are not working properly.

MySQL5 With Php5
i was using mySQL with php
i have updated my php to php 5 aand i have myql5
(i was instaling wamp-5)

but now i am getting an error like this

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in
C:Typo3htdocsMyfile.php on line 3
Connection failed.

But when i stop new mySql and start my old mySql every thing os ok.

how can i work in mysql5 with php5.

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)

MySQL5 Installation With PHP5
I have installed Apache webserver v2.2, PHP5, and MySQL 5.
I got Apache and PHP to work just fine with one another, but problems seem to arise everywhere when it comes to MySQL.I have followed all the tutorials that I could find out on the internet,but MySQL still fails to run,when I conduct the test under phpinfo.php.

I have uncommented the php extension in the php conf file,but it still doesn't collaborate with MySQL at all.When I start MySQL under the service window, it starts up just fine,but when I go back to the service window (after I close it),it shows it with a status of being stopped.

I'm running the server under the following DIRs:

Apache: C:webserver
PHP5: C:webserverPHP
MySQL5: C:webserverMySQL .

PHP5.2.5 Can't Connect Mysql6.04
test code:

<?php
mysql_connect("localhost:3306:mydatabase", "root", "123") or
die ("Could not connect" . mysql_error());
?>

run result:

Fatal error: Call to undefined function mysql_connect() in E:Program FilesApache Software FoundationApache2.2htdocszysindex.php on line 2
=================================================================================
copy php.ini php_mysql libmySQL.dll was copy directory.

PHP5 And Stored Procedures
Not sure if this is the right forum as it's partly a PHP question. I have set up the mysqli extension and created all the correct permissions in the database.

The problem is that I have several queries on the page, only one of which is a stored procedure (the first one). As soon as I run the SP the other normal queries fail, with no error message. If i change back from the SP and replace it with a straight query everything works.

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 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'

V. 4.1.7 + Php4 Works, + Php5 Problems
I am running:

Mac OS X 10.3.7
apache 2.0.52
MySQL 4.1.7
php 4.9.3 & php 5.0.3

I have an html form that "POST"s data to a db.
I have a "GET" script to repopulate form for editing.
Everything works fine with php 4.9.3.

With php5.0.3 the data is "POST"ed just fine
(I used a different GUI app to check)
When I try to "GET" said data, form is returned empty?

I have all error reporting turned on = nothing.
I have all backwards-compatibility directives in
php.ini config file turned on.

Mysql5 Setup Php5, Apache2
Trying to setup mysql5 to run with apache 2 and php5 and having very little luck. I've followed instructions from many sites and yet it still isn't being recognised when using the php functions to connect to the db.

mysql runs fine on it's own as I've been using it. I've downloaded the *.dlls from mysql and installed them in the correct dir's, uncommented the mysql dll in php.ini and restarted apache.

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?

JNDI Datasource Configuration Fo MySQL 4.1
I am now in charge of of Java web application that is hitting a MySql database version 3.1. We are in the process of setting up a new box with MySql 4.1. The developer who wrote the application is using technology from the Apache foundation to connect to the database via jsp's (ie. no struts). The technology is referred to as Database Connection Pool Configuration.

Installing Mysql5 (winXP, Apache2, Php5)
Using window XP.

I install Apache_2.0.55, PHP 5.1.2 installer.
After testing, server can run with php codes properly.

However,
How to install mysql5 and combine with Apache3+php5??
Where should i choose for install path way??
Should i choose C:Apache2 ???

I decide to install mysql-essential-5.0.18-win32.msi and the path way is C:mysql

finish installation.....

How can i start mysql5??? directly double-click mysql.exe => a "bee" sound heard and the file self -close immediately. I try to click other exe diles and all of them self-close immediately. Code:

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.

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.

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?