02-03-2012
Install Mysql 5
sudo su //if you aren't root user
apt-get install mysql-server mysql-client
Edit configuration file if necessary
nano /etc/mysql/my.cnf
Type following command for start, stop, restart mysql
sudo /etc/init.d/mysql start
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql restart
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
how do i install php & mysql with apache on suse linux ???
apache was installed and configured when i installed linux.
all its files are in different folders. e.g http files in usr/local/httpd/htdocs/ and its configs are in etc/httpd/
so how do i install php and get it to work with apache and... (4 Replies)
Discussion started by: perleo
4 Replies
2. AIX
Hello UNIX gurus, I need to install the mysql odbc connector with unixODBC on my AIX 5.3 machine. I have a mySQL database running on another server (Ubuntu 7.04). The SQL database works fine. The problem I am having is when trying to run ./configure for mysql-connector-odbc it seems to be looking... (1 Reply)
Discussion started by: raidzero
1 Replies
3. AIX
Hello All:
I've been asked to install mysql on AIX box and I have very little experience in UNIX. Does anybody have any step by step directions on installing MYSQL?
Any guidance would be appreciated! Thanks (1 Reply)
Discussion started by: rmnv
1 Replies
4. Linux
Hi, hopefully someone can help me. I am trying to set up LAMP on Fedora 11 starting with MySql. I downloaded the mysql-5.1.40.tar.gz tarball and unpacked it all. This created the mysql-5.1.40 directory. Next I ran the
./configure command.
Following this I ran the make command to compile but... (2 Replies)
Discussion started by: patcom
2 Replies
5. Ubuntu
How to install updates/required patch in ubuntu 11 in offline mode.
Since I can't connect internet to my laptop, I can't update it online. Hence I need to learn the alternate method.
I mainly want to be able to run audio and video files.
The available music player on ubuntu11 is banshee
I... (0 Replies)
Discussion started by: animesharma
0 Replies
6. Red Hat
I have removed php-5.1.6-27.el5 from our system. Because I installed it without mysql before.
How can I install php together with mysql.
# rpm -qa | grep mysql*
libdbi-dbd-mysql-0.8.1a-1.2.2
mysql-5.0.77-4.el5_4.2
mysql-server-5.0.77-4.el5_4.2
mysql-connector-odbc-3.51.26r1127-1.el5
##... (5 Replies)
Discussion started by: getrue
5 Replies
7. Ubuntu
Hi Guys..
I want to install Linux on my portable hard drive.
I created a 20GB partition in my hard drive for linux, Now I want to make it bootable mean when I connect it to system n start the system it will start the LINUX and when start without usb-hard drive it should start the windows.
... (3 Replies)
Discussion started by: atul9806
3 Replies
8. Linux
Hi ,
I have tired several times and tried a lot to install CRM in Centos Linux i686 but while im opening in browser for installing it shows database error as
Unable to connect to database Server. Invalid mySQL Connection Parameters specified
This may be due to the following reasons:... (0 Replies)
Discussion started by: babinlonston
0 Replies
9. Web Development
Hi,
I'm on a Raspberry Pi with Raspbian Wheezy.
I urgently need to get MySQL running with PHP, but I get an error.
For example:
$con=mysql_connect("127.0.0.1","root","******","ids");
gives
PHP Fatal error: Call to undefined function mysql_connect()
So, I found I needed to install some... (2 Replies)
Discussion started by: FreddoT
2 Replies
10. HP-UX
Gd afternoon
I am trying to run my website made in php-mysql on a HP-UX system but dont know how to install and run services of Mysql.
Kindly provide appropriate solution for installing mysql on HP-UX system.
thanks in advance. (1 Reply)
Discussion started by: kumar.ashishcs
1 Replies
LEARN ABOUT CENTOS
mysql_tzinfo_to_sql
MYSQL_TZINFO_TO_S(1) MySQL Database System MYSQL_TZINFO_TO_S(1)
NAME
mysql_tzinfo_to_sql - load the time zone tables
SYNOPSIS
mysql_tzinfo_to_sql arguments
DESCRIPTION
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. It is used on systems that have a zoneinfo database (the
set of files describing time zones). Examples of such systems are Linux, FreeBSD, Solaris, and Mac OS X. One likely location for these
files is the /usr/share/zoneinfo directory (/usr/share/lib/zoneinfo on Solaris). If your system does not have a zoneinfo database, you can
use the downloadable package described in Section 9.6, "MySQL Server Time Zone Support".
mysql_tzinfo_to_sql can be invoked several ways:
shell> mysql_tzinfo_to_sql tz_dir
shell> mysql_tzinfo_to_sql tz_file tz_name
shell> mysql_tzinfo_to_sql --leap tz_file
For the first invocation syntax, pass the zoneinfo directory path name to mysql_tzinfo_to_sql and send the output into the mysql program.
For example:
shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
mysql_tzinfo_to_sql reads your system's time zone files and generates SQL statements from them. mysql processes those statements to load
the time zone tables.
The second syntax causes mysql_tzinfo_to_sql to load a single time zone file tz_file that corresponds to a time zone name tz_name:
shell> mysql_tzinfo_to_sql tz_file tz_name | mysql -u root mysql
If your time zone needs to account for leap seconds, invoke mysql_tzinfo_to_sql using the third syntax, which initializes the leap second
information. tz_file is the name of your time zone file:
shell> mysql_tzinfo_to_sql --leap tz_file | mysql -u root mysql
After running mysql_tzinfo_to_sql, it is best to restart the server so that it does not continue to use any previously cached time zone
data.
COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/).
MySQL 5.1 04/06/2010 MYSQL_TZINFO_TO_S(1)