Topic: Installing MySQL 5.6

[kingsley]

I have successfully installed Apache and PHP, but i was facing a problem with installing MySQL.

I have downloaded mysql-5.6.10-win32.zip from http://www.mysql.com/downloads/mirror.php?id=412070

I did unzipped it into C:\mysql folder but i can't found any C:\mysql\*.ini files as have mentioned in http://www.apachelounge.com/viewtopic.php?t=2394.

- Sorry for my bad English

[Steffen]

MySQL 5.6 is far new and has other .ini files.
And is not yet proven.

Better to use 5.5 (now 5.5.30): http://dev.mysql.com/downloads/mysql/5.5.html#downloads

If you stil want 5.6 use the installer:
http://www.mysql.com/downloads/installer/5.6.html

Btw, saw in the setup guide you use is outdated for 5.5:
mysqld-nt.exe is mentioned there, must be mysqld.exe

Steffen

[DnvrSysEngr]

I have to ask, did you run the installer program?

When you run the installer it will create the mysql.ini file. Also, by default, it will install MySQL program into c:\program files\mysql or c:\program files (x86)\mysql

[Steffen]

Nope, still on the 5.5 bandwagon.

[kingsley]

steffen, which one i should download?

Windows (x86, 32-bit), ZIP Archive
- mysql-5.5.30.zip

or

Windows (x86, 32-bit), ZIP Archive
- mysql-5.5.30-win32.zip

[Steffen]

Windows (x86, 32-bit), ZIP Archive - mysql-5.5.30-win32.zip

Steffen

[DnvrSysEngr]

Hope my previous comment did not get misinterpreted. It was intended for the original poster.

I have been using MySQL 5.6 since it's development and have not encountered any issues. I am however only using it as a backend for WordPress.

[kingsley]

Thanks to steffen and DnvrSysEngr, mysql is working now

Btw, i have also installed phpmyadmin (it requires username and password to login). Anyway can any of you explain here how to set password for root user either in cmd, ini file or phpmyadmin and what else i should edit in my.ini of MySQL?

Sorry, i just can't understand the documentation in mysql.com

[DnvrSysEngr]

I have my phpmyadmin set up in the folder that contains my websites so that i can type in http://localhost/phpmyadmin

As for logging into phpmyadin, the username and password will be what you entered into mysql's initial configuration when you were prompted for a username and password to use for mysql.

Hope that helps.

- S

[James Blond]

Open the command line.
cd to mysql bin folder

type "mysql" as user choose root (if not choosen by default) as password just press enter since it is empty by default

than

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

Replace the password with the password that you want to use.

done

[kingsley]

James, seems does not work.

C:\Windows\System32>cd c:\mysql\bin

c:\mysql\bin>mysql -root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.5.30-log MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> UPDATE mysql.user SET Password=PASSWORD('secret') WHERE User='root';
Ignoring query to other database
mysql>

[CamaroSS]

[kingsley]

Thank guys, everything is working fine now

You guys are just awesome!!