click the green ‘+' icon on the right hand side > then: To verify this, you can do: ssh localhostĪlso, to access web server and ssh on virtualbox, you must go into ‘Settings' > ‘Network' > click on ‘Advanced' arrow > click ‘Port Forwarding'. This service will start running as soon as it is installed. Installing an SSH server sudo apt-get install openssh-server Then restart the server: sudo service apache2 restart Next, enable php5-mcrypt extention: sudo php5enmod mcrypt Then provide a password for phpmyadmin to register with the database server, and confirm. Select ‘YES' on next prompt to configure database for phpmyadmin with dbconfig-commonĮnter a password for the database's adminstrative user. Hit “SPACE”, “TAB”, and then “ENTER” to select Apache. IMPORTANT: When the first prompt appearch, apache2 is highlighted, but not selected. Install phpMyAdmin: sudo apt-get install phpmyadmin To install optional PHP components, see this: Restart the Apache web server: sudo service apache2 restart html files: sudo nano /etc/apache2/mods-enabled/dir.confĪdd the PHP index file to the first position: ĭirectoryIndex index.php index.html index.cgi index.xhtml inde$ To make the web server to prefer PHP files over. Install PHP $ sudo apt-get install php5 libapache2-mod-php5 php5-mcrypt UPDATE: To install Latest PHP $ sudo add-apt-repository ppa:ondrej/php Securely Administer MySQL with an SSH Tunnel MySQL Tuner is an excellent starting point to optimize a MySQL server, but it would be prudent to perform additional research for configurations tailored to the application(s) utilizing MySQL on your Linode. The output will show two areas of interest: General recommendations and Variables to adjust. You will be asked for the MySQL root user’s name and password. Install MySQL Tuner from Ubuntu’s repositories: $ sudo apt-get install mysqltuner The longer the instance has been running, the better advice MySQL Tuner will give. Ideally, the MySQL instance should have been operating for at least 24 hours before running the tuner. MySQL Tuner is a Perl script that connects to a running instance of MySQL and provides configuration recommendations based on workload. Threads: 1 Questions: 15 Slow queries: 0 Opens: 123 Flush tables: 1 Open tables: 42 Queries per second avg: 0.018 Additional options to tune MySQL or just skip to Step 3. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. You should see output similar to this: mysqladmin Ver 8.42 Distrib 5.7.16, for Linux on x86_64Ĭopyright (c) 2000, 2016, Oracle and/or its affiliates. For example, this command says to connect to MySQL as root ( -u root), prompt for a password ( -p), and return the version. If MySQL isn't running, you can start it with: $ sudo service mysql startįor an additional check, you can try connecting to the database using the mysqladmin tool, which is a client that lets you run administrative commands. You'll see the following output: * MySQL Community Server 5.7.16 is running Testing MySQL: $ sudo service mysql status You will be prompted to enter to password for the user root that you just created. To check the mysql version: $ mysql -version Choose a secure one and make sure you remember it, because you'll need it later. You'll be prompted to create a root password during the installation. $ sudo apt-get install mysql-server php5-mysql One solution is that when you select ‘OK' on the first screen to exit and you return to the command line, just continue with the code below. NOTE: I have had problems where the prompts would not let me proceed with the installation when I selected mysql 5.7. Once the option says mysql-5.7, scroll down on the main menu to Apply and press ENTER again. If it doesn't, press ENTER, then scroll down to mysql-5.7 using the arrow keys, and press ENTER again. The MySQL Server option, which is highlighted, should say mysql-5.7. You'll see a prompt that asks you which MySQL product you want to configure. $ sudo dpkg -i mysql-apt-config_0.7.3-1_all.deb How to Upgrade MySQL from 5.5 to 5.7 $ sudo apt-get update If installing on DigitalOcean, go to the ip address of the machine and check that you see the Apache2 Ubuntu Default page. Install apache server $ sudo apt-get install apache2 Assuming you have ubuntu already installed via virtualbox or direct install on pc:įirst, always do this on new ubuntu installs: $ sudo apt-get update
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |