CruzIT
Monday January 21, 2019 - 15:44:32 PM

Registered Linux User #440901    


 
Login    Register
Login Required

MySQL Database Server Information

MySQL has been the database server of choice for a very large number of projects ranging from very small internal applications to huge applications (like Google's Gmail for instance)
MySQL is a fast, stable and true multi-user, multi-threaded SQL database server. SQL (Structured Query Language) is the most popular database query language in the world. The main goals of MySQL are speed, robustness and ease of use.

Note: This area is for MySQL version 5.

Performance Tuning and Monitoring articles are in the works. Stay tuned. (Pun intended.)

 

Howto install “MySQL” on Ubuntu or a Debian based machine.

Do these commands as an administrative user. We are using an Ubuntu 8.10 machine for the following.

First:

Open a terminal session.

sudo apt-get install mysql-server

This will install the latest stable version and the dependencies required.
If you have a GUI (graphical user interface) installed you may want these also:

sudo apt-get install  mysql-admin mysql-client mysql-navigator mytop gmysqlcc

Second:

During the install you will be prompted for a database root account password. Put something in there! The default is no password - which may make it a little easier for developing, however anyone can get to the data if they can connect to it. If you weren't asked for the password, you may have used some other package management software or are using a different version of Linux. Just open a terminal and issue the following:

mysqladmin -u root password yourrootsqlpassword
mysqladmin -h yourfqdmachinename -u root password yourrootsqlpassword

"yourfqdmachinename" means your Fully Qualified Domain Name - Internal Name (somehost.somewhere.local or somehost.com - if it's a live machine connected to the internet)

Third:

If you need to connect to this database remotely - don't just answer yes right away, think about it for a minute... you will need to edit a file: Substitute your favorite editor in place of gedit if need be: sudo gedit /etc/mysql/my.cnf find the line that looks like
bind-address = 127.0.0.1
and comment it out (add a "#" in front of it) to make MySQL listen on all addresses or change 127.0.0.1 to an ip address on your machine. I have found that it's usefull to have an extra NIC (Netork Interface Card) just for some applications I want to access remotely, however just inside my LAN - it's much safer than having the application listening on all interfaces and still let's me connect to it from within the internal network for developers.

Forth:

Restart MySQL instance
In a terminal:

sudo /etc/init.d/mysql restart
then
sudo netstat -tap

You get something like:

tcp        0      0 *:mysql                 *:*                     LISTEN      3622/mysqld     

What you're looking for is the part that says "0 *:mysql " if you're listening on all interfaces.
If you're listening on my suggested internal only address it would show something like:
0 yourmachinename.local:mysql

Fifth:

You should have a running MySQL server now!
Try out some of the tools installed earlier, "msql-admin" is a good start. It's Under "Applications - Programming" if you're using the standard Ubuntu Desktop Gnome Display Manager in Debian (or just mysql-admin in a terminal).

Have Fun!

Collecting For A Server Upgrade  

Time since last reboot: 27 days, 18 hours, 10 minutes , 35 seconds

“Windows - Just Say No”

@ Active Member Project Honeypot  email addresses

This page was last modified on 09/1/18 @ 10:33:49:pm
This file name: info_mysql.php

Questions, Comments, Suggestions or Requests should be sent to:  ronnie@cruzit.com 

There have been  8026  Unique Visitors (IP Addresses) to this site.

Current users online : 19
Maximum users at a time : 50
Last 25 attacks have come from:
188.209.49.164
77.75.79.62
23.228.96.82
108.172.246.109
134.249.54.230
77.75.77.17
46.229.168.149
46.229.168.132
157.55.39.104
40.77.167.6
46.119.115.106
77.75.77.11
157.55.39.52
37.187.95.218
91.210.145.247
77.75.78.162
94.158.245.114
77.75.76.162
34.217.84.79
185.225.17.191
185.220.101.44
103.243.25.104
46.119.121.84
77.75.78.163
46.229.168.138

There are currently 25 unique IP addresses blacklisted.

Public cruzit.com Server Status
server offline limelight  web service
 Aw Crap!, It's Off-Line
server offline limelight  mail service
 Aw Crap!, It's Off-Line
server online www  web service
 Is On-Line
server online mx 08  mail service
 Is On-Line
server online www01  F/O web service
 Is On-Line
server online mx 09  mail service
 Is On-Line
server online tertiary  DNS service
 Is On-Line
server online mx 10  mail service
 Is On-Line

©Copyright 2004-2019 - cruzit.com - Redd Enterprises™, Inc.,  All Rights Reserved.
Ubuntu® is a registered trademark of Canonical Ltd.
Linux® is a registered trademark of Linus Torvalds.
Apache® is a registered trademark of The Apache Software Foundation.
PHP® is a registered trademark of The PHP Group.
MySQL® is a registered trademark of MySQL AB in the United States, the European Union and other countries.
All other product and service names mentioned are the trademarks of their respective companies.

 

pretrial
pretrial
pretrial
pretrial
Let us know what you think! finance@homelandcomputersecurity.com