Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Localhost & MySQl

connecting to MySQl from a localhost

8:55 pm on Nov 24, 2011 (gmt 0)

New User

5+ Year Member

joined:Nov 22, 2011
posts: 5
votes: 0

I have wampserver installed in my system, and i'm using it in previewing my site before uploading to the web server, and now i've reached the stage of authenticating users, i want to know how i'm gonna create a database that i'll connect to from MySQl
2:31 pm on Dec 1, 2011 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member jab_creations is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Aug 26, 2004
posts: 3168
votes: 22

I'd recommend using phpMyAdmin for starters.

MySQL also has a program called MySQL Workbench that you can download from the main MySQL site here: [dev.mysql.com...]

Unfortunately it requires .NET 4 which you can download here: [microsoft.com...]

I highly recommend enable logging of MySQL queries (you should also be intimately familiar with Apache's access and error logs).

MySQL has a "my.ini" file for configuration however you can use MySQL Workbench to enable logging albeit to the database while I prefer a file myself as if the MySQL service becomes unavailable I can still access a regular file. You should be able to change these around if you want to set them manually...

log_error = "C:/mysql/data/mysql.err"
pid_file = "mysql.pid"
general_log = 0
general_log_file = "C:/mysql/data/mysql.log"
slow_query_log = 0
slow_query_log_file = "C:/mysql/data/mysql-slow.log"

...or in MySQL Workbench...

1.) SQL Development.

2.) Open connection (localhost), save the password.

3.) Server Administration.

4.) Adopt the already tested connection.

5.) Once admin tab is open go to Options file under the CONFIGURATION header on the left menu bar.

6.) Go to the Log tab.

Now logs are great and all but what you really want is a log viewer that will empower you to quickly track things down such as MySQL write commands or HTTP error codes in the Apache access log for example. I highly recommend Tail for Win32. Go to Settings [menu], Keywords and add terms such as 403, 404, 500, DELETE, INSERT and UPDATE along with colors. It's a real time log viewer (there is sometimes a delay of upwards of 20 seconds on rare occasion I've noticed). It's not entirely perfect, it just opened minimized and I had to right-click and maximize it to make the window viewable. Still it's a very powerful tool despite a couple flaws.

Do all that and you'll be ahead of what most people are working with. :)

- John
12:28 pm on Jan 4, 2012 (gmt 0)

New User

5+ Year Member

joined:Nov 22, 2011
posts: 5
votes: 0

Thanks man, this has really solved my problem

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members