Jump to content

Archived

This topic is now archived and is closed to further replies.

sqrl

Install MySQL for local development

Recommended Posts

Partially answered scroll down...

When installing mysql without tcp/ip support I can't login from command line.

Doing this tutorial:
http://www.tanguay.info/wamp/installPhp5.php5?step=14

Share this post


Link to post
Share on other sites
localhost:8080

Anything after the colon is the port number.

What are using to connect to MySQL DB?

Share this post


Link to post
Share on other sites
I am using this tutorial:
http://www.tanguay.info/wamp/installPhp5.php5?step=14

-- go it to work see below --

mysql -r -p at command line to get into it doesn't work.

Share this post


Link to post
Share on other sites
What are using to connect to MySQL DB?

Command line as stated in tutorial

Perhaps I should just write a php page to connect?

I'd like to get mysql manager going but this is all so unclear :(

Share this post


Link to post
Share on other sites
got help on mirc.

The sub folders must be deleted after you uninstall otherwise old passwords get stuck in there.
I still can not get it to work without being a security risk (enabled tcp/ip)

That is so lame that the uninstaller does not remove all the folders and files! That is what uninstall means.

Share this post


Link to post
Share on other sites
When mysql is installed without enable TCP/IP it naturally gets an error when logging in command line mysql -u root -p

The error is: Can't connect to MySQL server on 'localhost' (10061)

How then is mysql accessed?

Share this post


Link to post
Share on other sites
Well Sqrl,
Sorry to overwhelm you with help but check out this link
http://dev.mysql.com/tech-resources/articles/securing_mysql_windows.html
See step 6
I'm reading it now and it talks about named pipes etc...
What a joke eh? - You'd think the standard install would not work online unless you did check a bunch of boxes with security warnings.

Share this post


Link to post
Share on other sites
So this will log you in on command line:
C:\>mysql -h . -u root -p 

This will connect to the server using named pipes. With recent (4.1 and higher) servers you can also use the --protocol=pipe option instead of specifying -h . on the command line:

C:\>mysql --protocol=pipe -u root -p

when you installed it without tcp/ip support

Now how to make php see this we'll see...

Share this post


Link to post
Share on other sites
going to give asp and microsoft server a try. 2 days lost.
You must be willing to dig deep and spend lots of extra time fiddling with files with this open source stuff.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.