Installing MySQL

For Linux


sudo apt-get install mysql-server bind-address = 127.0.0.0.1 bind-address = [your server ip address] /etc/init.d/mysql restart

, install the package. On most linux distros it is real simple. The package name is mysql-server, depending to the flavor. First

During the installation the installer will prompt for a password. Pick a good one. And that's all there is to it! The install part that is. When the installer is done MySQL Server will be up and running on port 3306, the default port.

However, By default the server is bound to the local host address 127.0.0.1. If the server needs to be accessed from a remote client then change the bind-address in the /etc/mysql/my.cnf file. Look for this line:

...about half way down the file... then modify it...

Since this file my.cnf is only read once during startup, the server will need to be restarted. It's pretty simple. Execute this command:

And that's really it. You should be able to access the server from any client... forign or domestic.

CREATED 2012-11-22 02:55:52.0

00-18-23

UPDATED 2012-11-22 03:25:11.0

For Windows


The install on Windows is a little more detailed... but not at all scarey.

  • First - download the installer from MySQL's site. You will need to log in to get it. If you don't have an account you need to create one. It's a good thing. Oracle has a lot of cool stuff.
  • Second - install it. It does everything for you.

CREATED 2012-11-22 03:25:12.0

00-18-24

UPDATED 2012-11-22 03:25:16.0

Knowledge

L
I
N
K
S

DBID: db.wam

Page Server: Ithica

©2012 Leistware Data Systems

      Hello anonymous