Jump to content

[TUT] MySQL Configure - UPDATED 2012-04-08


Todd

Recommended Posts

  • 3 months later...
  • Replies 61
  • Created
  • Last Reply

Top Posters In This Topic

  • 3 weeks later...

Yeah, not just free webhosts. It's a pretty big deal security wise to let in SQL sessions over the innerweb. Also I would suggest using localhost instead of 127.0.0.1, because then the MySQL travels through a pipe instead of over TCP protocol (it's more optimized).

http://dev.mysql.com/doc/refman/5.5/en/ ... erver.html

Also I would suggest using MySQL Workbench. It's a GUI for MySQL. The biggest advantage is how it lets you create Entity Relationship Diagrams, which makes implementing the database into the code a lot more clear. It also comes with the newest version of MySQL server.

http://dev.mysql.com/downloads/workbench/5.2.html

Link to comment
  • 2 weeks later...
Exactly. Webhosts do not allow database connections from anywhere else than the server, you can bypass this with PHPSDK for MTA :)

There are lots that allow ( if you mean a webhosting service and not a home server - even if it was a home server, it'd be possible ) - You can do that in CPanel ( I don't know if other panels let users do such things because I never used any others ).

Link to comment
  • 2 months later...
  • 2 months later...
Error: MySQL shutdown unexpectedly. 
22:08:37  [mysql]   This may be due to a blocked port, missing dependencies,  
22:08:37  [mysql]   improper privileges, a crash, or a shutdown by another method. 
22:08:37  [mysql]   Check the "/xampp/mysql/data/mysql_error.log" file 
22:08:37  [mysql]   and the Windows Event Viewer for more clues 
22:09:43  [mysql]   Attempting to start MySQL service... 

:|

Link to comment
  • 2 weeks later...
  • 2 months later...
  • 1 month later...
  • 2 weeks later...
  • 4 months later...
  • 2 weeks later...
  • 1 month later...
  • 4 weeks later...
Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.

×
×
  • Create New...