[fixed]error n°1364 in installing MySQL server

[rumpilstilskin]

Hi,

Sorry to be back to you guys with another problem.

I am trying to install MySQL server and despite of many attempts and researches on MySQL documentation and forum, I cant find the solution.

I always have the error Nr. 1364 popup at the end of the installation.

I opened a TCP acces on port 3306 on my modem, but it still wont work.

What is this « authentification_string » mentioned on the error popup?

Should I open the public port with 3306 ?

Should the name of my Lan server be part of MySQL?

I'd be gratefull if you could help^^

Error Nr. 1364 :

Modem :

[Cyberfreak]

Forget about the modem, this is only relevant for connection, but not for install. I think there ist another application using the port, like an older SQL Server or a third parity 1-Click-Tool for Mangos Server. Check your running services.

[rumpilstilskin]

Hi,

Thanks for your answer.

Not easy to check on what is running, process and services are numerous !

I checked on installed programs and found the following Microsoft SQL Servers installed. They seemed to have been installed along with Visual C++ 2008.

Could the problem be solved in erasing those SQL Microsoft Server? Or do I need them with Visual C++ ?

Microsoft SQL :

SQL Server :

[antiroot]

I don't think Microsoft SQL Server is conflicting it listens on tcp port 1433 i believe, and MySQL listens on tcp port 3306

But you can double check using this to see if anything is listening on port 3306

netstat -an | find "LISTENING"

It looks like the configuration wizard doesn't function correctly when it attempts to add new users

http://bugs.mysql.com/bug.php?id=59038

it's a very English heavy bug report, basically windows 7 users are having this error when they configure the mysql install in strict mode. The field authentication_string is NOT NULL but the wizard attempt to insert NULL which causes an error

the work around in the report is

A work around is to stop the configuration wizard when it bombs, go in and mark the

mysql.user.authentication_string column as nullable, then re-run the configuration

wizard, which will then complete normally and successfully "apply security settings."

Edit: Although I've not installed mysql on windows in a while, I wonder if you could just tell it not to add any users at all (root is already there of course) then it wouldn't need to insert any users

[rumpilstilskin]

Thanks for this very precise analys of my problem antiroot,

It seems you point out the solution of the problem... it's going to be tough, as you might have understood i'm not really an expert in programming^^... and this is little to say^^

I'm learning here.

To begin with you quote :

A work around is to stop the configuration wizard when it bombs, go in and mark the

mysql.user.authentication_string column as nullable, then re-run the configuration

wizard, which will then complete normally and successfully "apply security settings."

Could you please explain me how to "go in and mark the mysql.user.authentication_string column as nullable"?

Thanks^^

[rumpilstilskin]

Back again!^^

Well… I read the different point of vues of the Oracle peoples found in your thread antiroot … it was facinating… so much I dont understand!

At the end there is a thread to a patch for the latest MySQL… but I wont try to work on the MySQL program.

I understood the latest MySQL version is bogued for Window Seven users, so I decided to install the 5.1 version… it went just smoothly.

Eventually it could be usefull to recommend the downloading of version 5.1 in the installing guide.

Next step is « Setting up the SQL connection »

SETTING UP THE SQL CONNECTION

Install and Run your SQLclient. In this case "SQLyog"

Click the "New..." button at the top of the window to create a new connection

Name the connection anything you like such "World Of Warcraft SQL Server"

Fill out the fields as indicated below:

MySQL Host Address: This is "127.0.0.1" or "localhost" if your SQLclient is on the same machine as the MySQL server. If you're accessing this from another computer, put the LAN IP address or the Internet IP address depending on your needs.

Username: Type in "root"

Password: This is the password you set up when you've installed the MySQL Community Server (See PART 12 - Installing and Configuring MySQL)

Database(s): Leave this blank for now

Click "Connect" and save the change

Unfortunatly I cant find SQLyog… *never felt so stupid*

Could you please point out on the following screens what should I run?

Thanks!

[antiroot]

I don't personally use sqlyog, but i don't believe it is part of mysql, it's a 3rd party program you'll have have to download and install separately. google sqlyog and it is the first result

Edit: The parts of the guide that tell you use sqlyog can also be done from the mysql client itself (the console screen with mysql>) sqlyog just gives a nice gui interface which is a little easier to work with for most users

[rumpilstilskin]

Thanks for your answer antiroot.

Going to search for a guide to work directely on the consol.