MySQL (Notes)

From Minor Miracle Software
Jump to: navigation, search

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