homepage Welcome to WebmasterWorld Guest from 54.227.11.45
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Localhost & MySQl
connecting to MySQl from a localhost
Starlyvil




msg:4390813
 8:55 pm on Nov 24, 2011 (gmt 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

 

JAB Creations




msg:4392947
 2:31 pm on Dec 1, 2011 (gmt 0)

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

Starlyvil




msg:4403517
 12:28 pm on Jan 4, 2012 (gmt 0)

Thanks man, this has really solved my problem

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved