MySQL (Notes)
MySQL Notes
External Links
http://www.mysql.com/
http://dev.mysql.com/doc/refman/5.5/en/
error code listing.
http://rackerhacker.com/2007/08/09/mysql-error-codes/
http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html
jdooley c_Vlogumn7ABC
Code
MySQL_local_Connection.perl works connecting to the local mysql.
my.ini -> bind-address="0.0.0.0"
Configuration Files[1]
my.ini on Windows, my.cnf on UNIX.
Global my.ini settings
skip-networking -- turned off, MySQL can listen for IP connections.
bind-address="127.0.0.1" -- set to localhost,
Server Settings
my.ini
bind-address="0.0.0.0" #Allows connection from any IP
skip-federated # remote data storage disabled
Client Settings
This works with "any_host" host set to %
use DBI;
use DBD::mysql;
use IO::Handle;
my $dsn = 'dbi:mysql:mysql:<any_ip>:3306';
my $user = 'any_host';
my $pass = 'any_pass';
Internal Links
Parent Article: Databases