MySQL Forums - MySQL Installer for Windows

i had error when i instaled server 5.7 (1 reply)

carlos gutierrez — Fri, 24 May 2013 22:22:48 +0000

after the instals no starts mysql instance configuration wizard so i cant coniguure

Root login and data lost after restart (no replies)

Jacob Nicolaisen — Wed, 22 May 2013 12:34:58 +0000

I have installed MySQL 5.6 as a service on two windows 7 machines and on each I am experiencing the same problem: After restarting the machine I can no longer log in as root. I therefore have to recreate my root password and also the tables and data I previously created have been lost. Please advise.

Error while updating MySQL installer (no replies)

Andreas Kolbe — Mon, 20 May 2013 19:55:34 +0000

Hi everybody,

I'm running into an error when using the "Check for Updates" option with the "Maintenance" dialogue of MySQL installer. While all installed products are up to date, I'm asked to update Installer:

Update?
---------------------------
There is an update available to the MySQL Installer. Do you want to download and install it now?
---------------------------
Yes No

When clicking "Yes", it tries to download something, but at 0% I get

There was an error downloading the update. Please contact support.
---------------------------
OK

I'm running MySQL 5.6.11-log on Win2012, Installer seems to be 1.1.7.0 (at least thats what the exe-properties of MySQLInstaller.exe says).

All info is appreciated, thanks a lot!
//Andreas

where are the settings I made within the installer? (1 reply)

Peter Christov — Fri, 17 May 2013 12:39:15 +0000

Hello,

I installed MySQL Server (from mysql-installer-community-5.6.11.0.msi) and it seems, it runs OK.

Nevertheless I miss the file my.ini. I think I can rename the my-default.ini to my.ini and then I can also add the entries I need (e.g. innodb_file_per_table = 1). Is it so??

I am also wondering where the settings I made within the installer are (such as binary logging =on, Port 3306 and so on). I would like to be able to set binary logging =off and thought it can be done in my.ini

Thank you in advice!
Regards Peter

Workbench in Win 7 doesn´t start (no replies)

Dario Columbich — Wed, 15 May 2013 06:08:29 +0000

I had installed the a version that run perfect, but it lacked of migration tool, so I installed the new version workbenck for windows msi installer.
Since then, despite to try the latest version and one older, even the original one, the only thing I have is the initial windows that disappera inmedialtly and Workbenck doesn´t run.
I have search for a folder left for the older version, none. I have clean the registry, none. I have trie dto instal libraries redistributables VC 2010 the system alertm to have a new onee inatlled and od not et me install the one that is pointed form the workbench download page.
Any help, any idea, thank you.

Win Server Upgrade w MSQL 5.0 (no replies)

Granville Phillips — Thu, 09 May 2013 02:05:46 +0000

My IT dept is migrating my windows 2000 server to a new win 2008R2 server.

The MySQL version is MySQL 5.0.41-community-nt.

It seams I have had nothing but problems getting MySQL to work on the new 2008 server.

The install file I am using is mysql-essential-5.0.41-winx64.

Knowing the info above, is there anything I should do to the server before I try to attempt to install again?

Any help would be greatly appreciated!

New to mysql. Cannot get prompt line window to stay open (1 reply)

Jackie Mitchell — Mon, 13 May 2013 10:25:22 +0000

Cannot get mysql command window to stay open. It flashes then disappears. Need help.

ibdata1 file is getting deleted when uninstalled mysql5.6.10/11 (2 replies)

Rasheed Mohammed Abdul — Thu, 09 May 2013 07:33:44 +0000

I have installed mysql5.6.11 version. I kept the mysql\data folder in the installation directory itself. Then created two databases and few tables. Later i uninstalled mysql5.6.11 from my machine but here it is deleting all the files ibdata1 and other supporting files from the data folder except the newly created databases folder. Again if I installed in the same location then previous databases tables are not able to access. its saying doesn't exists. It was not happening with previous version i.e. mysql5.5

Can some one help on this plz? As i want to keep the data folder in the installed mysql folder only.

MySQL Adminitrator Error 2003 to conect MySQL Server Instance (no replies)

NS Sevilla — Tue, 07 May 2013 16:19:27 +0000

MySQL Error Number 2003
Can´t connect to MySQL server on localhost (10061)

Reply from 127.0.0.1 Time=0m TTL=128

MySQL Service is running and port 3306 is open, too

Could you help me? Is very important in this moment for me.

Thanks

Delete WINDOWS-0Z3XMBB.log (no replies)

registered Ok — Mon, 06 May 2013 22:39:11 +0000

Hi,

I'm using windows server 2008 and I see file: WINDOWS-0Z3XMBB.log (txt) in mysql/data is very big (90 GB)

Is it safe to delete this file?

Thanks in advance.

mysql database server issue (2 replies)

Harikrishna Ravipati — Wed, 08 May 2013 13:26:23 +0000

Hi All,

I tried to run mysql database server like below,i am getting pid ended.

[mysql@TEST-LSM-R app] $ ./bin/mysqld_safe&
[1] 6724
[mysql@TEST-LSM-R app] $ 130503 09:07:32 mysqld_safe logging to '/db/mysql/data/TEST-LSM-R.err'.
130503 09:07:33 mysqld_safe Starting mysqld daemon with database from /db/mysql/data
130503 09:07:33 mysqld_safe mysqld from pid file /db/mysql/data/TEST-LSM-R.pid ended

[mysql@TEST-LSM-R app] $ /bin/mysqld_safe --console --user=mysql
130503 12:44:29 mysqld_safe Logging to '/db/mysql/data/TEST-LSM-R.log'.
130503 12:44:29 mysqld_safe Starting mysqld daemon with databases from /db/mysql/data
130503 12:44:29 mysqld_safe mysqld from pid file /db/mysql/data/TEST-LSM-R.pid ended

plz can any one let me know why this issue coming.

Regards,
Hari

Run MySQL database server issue (no replies)

Harikrishna Ravipati — Fri, 03 May 2013 11:00:55 +0000

Hi All,

When i try to run MySQL database server getting below errors,

[mysql@TEST app] $ bin/mysqld safe --user=mysql &
[1] 9046
[mysql@TEST app] $ 130503 10:37:27 [Warning] Changed limits: max_open_files: 8192 max_connections: 151 table_cache: 4015
130503 10:37:27 [ERROR] Can't find message file '/usr/local/mysql/share/errmsg.sys'
130503 10:37:27 [Note] plugin 'FEDERATED' is disabled.
130503 10:37:27 InnoDB: The InnoDB memory heap is disabled
130503 10:37:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130503 10:37:27 InnoDB: Compressed tables use zlib 1.2.3
130503 10:37:27 InnoDB: Using Linux native AI0
bin/mysqld: Can't create/write to file '/db/mysql/tmp/iboBah3h' (Errorcode: 2)
130503 10:37:28 InnoDB: Error: unable to create temporary file; errno: 2
130503 10:37:28 [ERROR] Plugin 'InnoDB' init function returned error.
130503 10:37:28 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
bin/mysqld: Too many arguments (first extra is 'safe').
Use --verbose --help to get a list of available options
130503 10:37:28 [ERROR] Aborting

130503 10:37:28 [Note]

Plz let konw the solution for this issue.

OS --> Redhat linux 5 64-Bit
MySQL ---> mysql-advanced-5.5.17-linux2.6-x86_64

Regards,
Hari

Regards,
Hari

MySQL Essential 5.1.69 needed (no replies)

David Matheson — Thu, 02 May 2013 13:27:49 +0000

Needing the Essentials package for 5.1.69. Is it going to be released or just the noinstall .zip?

MySQL Installation on Linux (Installation of system tables failed! Examine the logs in /db/mysql/data for more information). (1 reply)

Harikrishna Ravipati — Fri, 03 May 2013 06:34:07 +0000

Hi All,

When i execute mysql installation script as fallows i am getting the below out put:

[mysql@test app]$ scripts/mysql_install_db -–user=mysql

output:

Installing MYSQL system tables....

Installation of system tables failed! Examine the logs in /db/mysql/data for more information.

You can try to start the mysqld daemon with:

shell> ./bin/mysqld --skip-grant &

and use the command line tool ./bin/mysql
to connect to the mysql database and look at the grant tables:

shell> ./bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /db/mysql/data that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install-db', and the manual section that describes problems on your OS. Another information source are the MySQL email archives available at http://lists/mysql.com/.

Please check all of the above before mailing us! And remember, if you do email us, you MUST use the ./bin/mysqlbug script!

Can any one plz let me know why this issue occuring.

Regards,
Hari

Cannot continue the installation. Please help me! (2 replies)

Alex Chan — Mon, 13 May 2013 08:13:13 +0000

Dear Support,

When running 'mysql-installer-community-5.5.31.0' in Windows 8(x32), the installer starts and then it reaches the step 'check requirements'. Then, I press the button 'Execute'.

The problem is that only 3 buttons 'Back', 'Execute', 'Cancel' can be seen. There is NO other button. Therefore, I cannot continue the installation.

Could you help me?

Kind regards.

MySQL 5.5.28 shut down automatically Problem (no replies)

Eric Jiang — Sun, 28 Apr 2013 03:29:25 +0000

Hello,

mysql 5.5.28 shut down automatically on Windows 2003 server platform.

This is the error I can find in the computer system management:
error program mysqld.exe, version 5.5.28.0, error module unknown, version 0.0.0.0,error address 0x19fb1c22.

Any advice? Thanks.

MySQL Installer download gone? (no replies)

Lars Werdes — Fri, 26 Apr 2013 09:19:23 +0000

Hello helpful folk,

I downloaded a 31,1 MB file named mysql-5.5.30-win32.msi from the MySQL download page a few weeks ago with the MD5 signature 36f0088ebdf752a4df7b5b6646e9b9b0. This installer package is gone now and all I see is http://downloads.mysql.com/archives.php?p=mysql-installer&v=5.5.30 with different signatures, is there a bug in the old file? Is there a changelist anywhere?

Many thanks in advance!

Best regards
Lars

MySQL Installer 5.6 for windows features selection failed (no replies)

Lizhe Xu — Thu, 25 Apr 2013 16:26:07 +0000

I used Mysql-installer community-5.6.10.1 on my Window 7 64-bit machine. I want to install 32 bit Mysql to meet some applications' need. I found two surprised things when I chose 32-bit in the architecture field on the Feature Selection window. First Mysql Server 5.6.10 was greyed out. After several failed attempts to fix it, I gave up and moved on. In the following window, it seemed the Mysql server was installed. Then it came the second surprise, my sql server installed is in 64-bit, not what I selected 32-bit. I wonder how to fix the problem and how to install 32-bit Mysql community-5.6 server on my Win 7 64-bit machine. Thanks.

Error Upgrade to 5.6.11 (no replies)

muklee lee — Mon, 22 Apr 2013 11:14:19 +0000

Recently, I've downloaded and installed MySQL 5.6 (mysql-installer-community-5.6.10.1.msi) into Windows Server 2008 R2. During the installation, I changed the installation directory to E:\softwares. The installation completed successfully, without any error.

Today, I try to upgrade MySQL to version 5.6.11 but failed. The upgrade is done using the 'Check for Updates' feature in 'MySQL Installer' (Start --> All Programs --> MySQL --> MySQL Installer --> MySQLInstaller.exe --> Check for Updates).

I selected all the available updates (MySQL Server 5.6.11 and Connector/J 5.1.24) and proceed with the installation. The download for both upgrades are successful but installation completed with error message 'Unhandled exception has occurred in your application. if you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. The specified service does not exist as an installed service'.

After that all the MySQL files were 'move' to directory C:\Program Files\, which suppose to be in directory E:\softwares. The MySQL NT service cannot be started and connection (ID/Password) to the database is no longer valid.

I am very new to MySQL. Is this considered a bug? Appreciate if anyone could help on this. Thank you.

XAMPP Installation on a Windows 2008 R2 Server (no replies)

Dwayne Todd — Sat, 20 Apr 2013 17:51:28 +0000

I have installed a application using XAMPP on a windows 2008 R2 server. I am trying to connect to the database using Mysql Connector from a PC that is not "localhost". I am getting...

"New XAMPP security concept:

Access to the requested directory is only available from the local network.

This setting can be configured in the file "httpd-xampp.conf".

The PC that I am using is logged on to a domain, as a user, and is passing the the domain name as a part of the logon request to the Mysql server.

So, could somebody please tell me what security/conf additions/changes need to be made to accommodate this need?

Thanks

Array of selectors: for loop vs. $.each (no replies)

Jack Hard — Sat, 20 Apr 2013 05:45:42 +0000

Given the following array of selectors (each of which are display: none in the our css) and for loop:

var arr = ['#home', '#news', '#tidy'];

for (i=0;i<=arr.length;i++){
$(arr).toggle();
}

What is an equivalent using $.each ( and presumably $(this) )?

MySQL files in Canon folders (no replies)

Furat Muhi AL-Din — Tue, 16 Apr 2013 20:56:10 +0000

This problem is not going away when I install MySQL using the Windows Installer.
After the installation, the client command line window only flashes. and some of the files go into the bin file inside the Canon folder in Program Files.
Is there any solution to that?

my sql download i do not know how to get the download to work? (no replies)

Declan Walsh — Wed, 10 Apr 2013 10:27:21 +0000

I have downloadeed the my sql download i do not know how to get the daqtabase to work.

MySQL Error - Unknown column 'xyz' in 'on clause' (1 reply)

Jack Hard — Wed, 10 Apr 2013 14:15:58 +0000

I recently upgraded the MYSQL version from 4 to 5 and I get this error..

Error No : 1054 Error : Unknown column 'c.city' in 'on clause'

`SELECT b.expirydate, a.ben_changed, a.amlnotes, a.processdate, c.phone AS beneficiaryphone, cpstate.statename AS collectionpointstate, cpcity.cityname AS collectionpointcity, cp.agentname AS collectionpointname, cp.agentaddress AS collectionpointaddress, cp.agenttelephone AS collectionpointphoneno, b.postcode AS customerpostcode, co.countryname AS bencountryname, st.statename AS benstatename, ct.cityname AS bencityname, a.depositbankname AS depositbankname, b.address AS customeraddress, b.phone AS customerphone, a.releasedate, a.releasedby, a.collectiontype, b.mobile AS customermobile, c.mobile AS beneficiarymobile, a.releasemessage, a.releaseorder, a.amlnotes, bf.bankname, a.branchname, a.accountno, a.ordertime, h.agentname AS payingagentname, a.cashcommission, d.agentname AS officename, a.orderdate, a.orderid, a.orderamount, a.agentcommission, e.username AS orderby, g.currencycode AS fromcurrency, f.currencycode AS currency, a.exchangerate, a.benamount, b.surname AS customersurname, b.firstname AS customerfirstname, c.surname AS bensurname, c.firstname AS benfirstname, a.orderstatus, a.saleid, a.benid, a.contactid
FROM contact_master b, ben_master c, agent_master d, sales_master a
LEFT JOIN agent_master cp ON a.collectionofficeid = cp.agentid
LEFT JOIN city_master cpcity ON cp.city = cpcity.cityid
LEFT JOIN state_master cpstate ON cp.state = cpstate.stateid
LEFT JOIN currency_master f ON a.currency = f.currencyid
LEFT JOIN city_master ct ON c.city = ct.cityid
LEFT JOIN state_master st ON c.state = st.stateid
LEFT JOIN country_master co ON c.country = co.countryid
LEFT JOIN currency_master g ON a.fromcurrency = g.currencyid
LEFT JOIN user_master e ON a.orderby = e.userid
LEFT JOIN payingagent_master h ON a.payingagent = h.agentid
LEFT JOIN bank_master bf ON a.bankname = bf.bankid
WHERE a.contactid = b.contactid
AND a.benid = c.benid
AND a.officeid = d.agentid
AND a.contactid = '2'
AND orderdate & gt ; = '2013-04-09'
AND orderdate & lt ; = '2013-04-09'
AND a.orderby != 'onlinewebsite'
ORDER BY orderdate, ordertime ASC
LIMIT 0 , 30'

Update of 5.1 install fails, then 5.6 install confuses me (2 replies)

Dave Merrill — Thu, 11 Apr 2013 02:30:40 +0000

Hi folks, and thanks for all the work on MySQL, as always.

I have MySQL 5.1 and 5.5 installed. I want to keep those versions, but update them with the latest fixes, and install 5.6.

Problem #1:

The 5.5.30.1 and 5.6.10.1 installers both think they can do both updates. I chose Install Updates, and the 5.5 update worked, but with either installer, the 5.1 update fails, a 404 error downloading the actual update. I'm trying to to upgrade 5.1.56 to 5.1.66. Log says this:
1: Download of product 'mysql-server-5.1-winx64' Download failed.

now what?

Problem #2:

After that, I wanted to install 5.6, so I chose Add/Modify Products and Features. I checked the boxes to install the server itself, no apps (have the latest workbench already, which it knows), all connectors, and docs. It said there are no additional requirements to be installed.

However, when it gets to the Execute confirmation screen, the 5.6.10 server, connectors, docs, and samples show as 'To be installed', as expected, but 5.1.56 shows 'Changes pending'.

What exactly does that 'Changes pending' msg mean? Will it try to update 5.1 to 5.6.10? I don't want that. There don't appear to be any options to update existing installs or not in this mode. My 5.1 instance is still working fine, i.e., it didn't get partly uninstalled by the earlier attempts whose "changes" might have been "pending".

Does it mean that it knows about an earlier upgrade attempt, but it's not going to do anything about it, just do the 5.6 install?

Thanks,
Dave

Can't run 5.6.10.1 installer on Windows XP 64 bit (no replies)

Clifford Cary — Mon, 01 Apr 2013 11:56:09 +0000

When I run the installer it goes about 70% of the way through "Gathering required information". Then there is a long pause followed by a dialog that says "Windows Installer service could not be accessed". I have confirmed that the installer service is running. I have stopped it and restarted it. How can I make the installer run?

Cannot set root password (2 replies)

JOHN JENNINGS — Tue, 23 Apr 2013 15:29:06 +0000

When installing MySQL 5.6 using the Windows installer everything works as the instruction manual says until I get to the screen where you're supposed to be able to set the root password (fig 2.16 in the ver 5.6 manual). On my server running Windows Server 2008 R2 the screen instead asks for the root password and gives me two other places to enter an account password. I have tried leaving root blank and have tried using the obvious default passwords, but installation always fails because I don't have the correct root password.

Any thoughts on why I'm not getting the screen to set the root password?

Any thoughts on what root password I could try to get past this screen?

Thanks for any help.

Where Is The MYSQL Settings File Located On A Windows Installation (no replies)

Jack Hard — Thu, 28 Mar 2013 03:06:53 +0000

I need to set "lower_case_table_names", but I don't have any idea where to start. I'm using XAMPP and I don't know where to look for the file or that the exact name of the file is. One source said my.cnf another said my.conf, but neither of those files exist on my drive. Is it possible I need to create such a file? And if so, what folder must I put it in for the settings to take?

Conversion of Commercial to GPL (no replies)

Brad Plumlee — Wed, 20 Mar 2013 16:06:51 +0000

This is more of a request than anything else.
When running the MySQL Installer for Windows I ran into the issue of owning a Commercial license. We use the SE version of Workbench which I want to continue to use. Could the installer be setup to handle those of us who use Commercial software to either check for updates for that or just ignore that it is there.

The small Windows Installer which existed for MySQL 5.5 (1 reply)

Pratyush Nalam — Fri, 22 Mar 2013 14:29:16 +0000

MySQL 5.5 had a nice 32.7 MB 64-bit MSI installer for Windows (http://dev.mysql.com/downloads/mysql/5.5.html). But 5.6 has just this one big 200~ MB installer for Windows. Won't the smaller version be released?