sqrl Posted August 30, 2006 Share Posted August 30, 2006 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 Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted August 30, 2006 Share Posted August 30, 2006 localhost:8080Anything after the colon is the port number.What are using to connect to MySQL DB? Quote Link to comment Share on other sites More sharing options...
sqrl Posted August 30, 2006 Author Share Posted August 30, 2006 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. Quote Link to comment Share on other sites More sharing options...
sqrl Posted August 30, 2006 Author Share Posted August 30, 2006 What are using to connect to MySQL DB?Command line as stated in tutorialPerhaps I should just write a php page to connect?I'd like to get mysql manager going but this is all so unclear :( Quote Link to comment Share on other sites More sharing options...
sqrl Posted August 30, 2006 Author Share Posted August 30, 2006 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. Quote Link to comment Share on other sites More sharing options...
sqrl Posted August 30, 2006 Author Share Posted August 30, 2006 When mysql is installed without enable TCP/IP it naturally gets an error when logging in command line mysql -u root -pThe error is: Can't connect to MySQL server on 'localhost' (10061)How then is mysql accessed? Quote Link to comment Share on other sites More sharing options...
sqrl Posted August 30, 2006 Author Share Posted August 30, 2006 Well Sqrl,Sorry to overwhelm you with help but check out this linkhttp://dev.mysql.com/tech-resources/articles/securing_mysql_windows.htmlSee step 6I'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. Quote Link to comment Share on other sites More sharing options...
sqrl Posted August 30, 2006 Author Share Posted August 30, 2006 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 -pwhen you installed it without tcp/ip supportNow how to make php see this we'll see... Quote Link to comment Share on other sites More sharing options...
sqrl Posted August 30, 2006 Author Share Posted August 30, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.