Site Sponsors:
Installing MySQL Server & Workbench 
In a previous article we praised the innovative way Red Had allows us to rapidly install things like MySQL.


For the new learner however, note that at the time of this writing that only the MySQL Client (mysql-client) toolset will be installed.

Service, Please


If you are looking to do some R&D on your local host (we use a Virtual Box), then one will want to also install the MySQL Server tools (mysql-server), as well:

su
yum install mysql-server

Thereafter (*) we can start the locus via:

service mysqld start

As well as subsequently begin the MySQL console interface simply by typing
mysql
at the console interface.

MySQL Workbench


For those of us who absolutely love Microsoft SQL Server's SQL Management Studio (SSMS), note that MySQL has a must-have graphical tool set, as well. Formerly known as "MySQL Administrator", we now call it the "Workbench."



No matter what we call it however, the Community Edition of the GUI is the very next item most R&D folks will want to download.



Again at the time of this writing however, there is often an installation caveat. Before installation, try
yum install http://ftp.altlinux.org/pub/distributio ... x86_64.rpm
if you run into problems whilst doing something like
yum install mysql-workbench-community-6.1.7-1.el6.x86_64.rpm
Once installed, merely enter
mysql-workbench
at the console to get things rolling.


Google Fodder


Installing the MySQL Server will resolve error message such as:
Error: Package: mysql-workbench-community-6.1.7-1.el6.x86_64 (/mysql-workbench-community-6.1.7-1.el6.x86_64) Requires: libtinyxml.so.0()(64bit)

[ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

-as well as:
mysqld: unrecognized service

or someday perhaps even:
mysqld: unrecognised service  ;-)





Ubuntu & Elsewhere


(*) Note that Ubuntu learns will want to use
sudo apd-get install mysql-server
sudo service mysqld start
rather than
yum ...
. Otherwise, everything else in this post will work the same.

[ view entry ] ( 1564 views )   |  permalink  |  related link

<<First <Back | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | Next> Last>>