Category » Database

There were 8 articles found in this category:

1. How do I install LAMP on my new basic server?
   Important Notes: This guide will show you how to install Apache, mySQL, and PHP from the Linux command line. Getting Started: Log into your server using SSH First, we'll install apache. Issue the following command to install apache: [root@server] yum install httpd mysql-server php mysql ...
2. How can I trouble shoot my MySQL database?
   MySQL troubleshooting. First, check the log. /var/log/mysqld.log has anything logged by the MySQL server itself. If that file doesn't exist, check the /etc/my.cnf for the location of the file. Look for the "log-error" setting. If there is an error when MySQL is trying to start, it'll show u ...
3. How do I manage databases in the Plesk control panel?
   The Plesk Control Panel has the ability to create multiple MySQL and PostgreSQL databases as well as multiple users within each database. Also, directly accessible via Plesk, are the links to phpMyAdmin and PhpPGAdmin, the PHP interface applications that abstract mysql or postgresql into a web ...
4. How can I configure remote access for mysql?
   Important Notes: This guide will help you configure your server to allow remote connections to your mySQL database. This guide is intended for server with the Plesk Control Panel installed. If you are with Managed Hosting, please login to https://serverportal.com/ and submit an A la Carte' w ...
5. Do you have some database performance tuning suggestions?
   The following are some database performance tuning strategies: Check that all columns where searches or sorts take place are indexed unless tables are very small or have high levels of updates. One place where indexes are overlooked (and very necessary) is on the parent column of a foreign key ...
6. What is the username and password to access MySQL on my Unix dedicated server?
   The username for root access to MySQL is “admin”. The password will be the same as your 'admin' password for the Plesk Control Panel login. Note: MySQL is configured to only allow access from localhost. This means you can only access the server from a MySQL management interface su ...
7. How do I optimze mysql?
   Important Notes: PHP/mySQL sites can often be slow because of the ammount of reasources needed. Often, these sites can be sped up simply by optimizing the configuration of the my.cnf file. Getting Started: You can check to see if your server is being overloaded by mySQL by issuing the top co ...
8. How do I back up a MySQL database from command line?
   Important Notes: This procedure will have to be done command line if you do not know how refer to the article "How do I connect to my Linux server using command line?"Getting Started: To back up the database you are going to use the mysqldump command: mysqldump -u [username] -p [passwo ...