![]() If the above commands work than you are able to connect to mysql on localhost and start using it. ![]() Type 'c' to clear the current input statement. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. MySQL will start automatically after the installation, to validate that it is installed and running properly you can do the following steps Verify MySQL is listening :/nfs# netstat -na | grep 3306Ĭonnect via the client :~# mysql -u root -p ![]() The apt-get command will also install the mysql-client package which is necessary to login to mysql from the server itself. I suggest making this password different than your servers root password especially if you have DBA's managing the MySQL instance but do not want them to have access to root on the server. Installing MySQL with apt-get :/nfs# apt-get install mysql-server mysql-clientĭuring the installation you will be asked to provide a root password. Check whether MySQL is installed :/nfs# dpkg -list mysqlĭepending on your system you may see packages with mysql in the name, if you do not see mysql-server than it is not likely that you have mysql installed. These steps are fairly similar for Red Hat based distributions and can be used by simply replacing apt-get with yum. The following steps outline how to install mysql on a Debian/Ubuntu server. Installing MySQL is a fairly common task for any systems administrator especially if that administrator is running a standard LAMP stack (Linux, Apache, MySQL & PHP/Python/Perl). In fact the contents of this page are even stored within MySQL. MySQL is used by everyone from the simple small business website to the large internet giants like Facebook, Google or Amazon. MySQL is the most popular open source relational database management system (RDBMS) in the world.
0 Comments
Leave a Reply. |