Jump to content


Photo

Install MySQL for local development


  • Please log in to reply
8 replies to this topic

#1 sqrl

sqrl
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 30 August 2006 - 03:01 PM

Partially answered scroll down...

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

Doing this tutorial:
http://www.tanguay.i...p5.php5?step=14


#2 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 30 August 2006 - 03:05 PM

localhost:8080

Anything after the colon is the port number.

What are using to connect to MySQL DB?

#3 sqrl

sqrl
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 30 August 2006 - 03:12 PM

I am using this tutorial:
http://www.tanguay.i...p5.php5?step=14

-- go it to work see below --

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


#4 sqrl

sqrl
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 30 August 2006 - 03:17 PM

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 :(


#5 sqrl

sqrl
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 30 August 2006 - 03:53 PM

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.


#6 sqrl

sqrl
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 30 August 2006 - 04:14 PM

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?

#7 sqrl

sqrl
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 30 August 2006 - 04:22 PM

Well Sqrl,
Sorry to overwhelm you with help but check out this link
http://dev.mysql.com...ql_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.


#8 sqrl

sqrl
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 30 August 2006 - 04:28 PM

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


#9 sqrl

sqrl
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 30 August 2006 - 06:22 PM

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.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users