
Install PhpMyAdmin
Phpmyadmin installations are of two types that is server specific and domain specific. Inorder to install phpmyadmin for the server Download phpmyadmin from https://www.phpmyadmin.net/home_page/downloads.php Download …
Phpmyadmin installations are of two types that is server specific and domain specific. Inorder to install phpmyadmin for the server Download phpmyadmin from https://www.phpmyadmin.net/home_page/downloads.php Download …
You can check whether the query cache is present in your MySQL server using the following statement: mysql> SHOW VARIABLES LIKE ‘have_query_cache’; You can defragment …
mysql -u -p -h By default you would use the root user with no password if connecting to localhost only. While it does simplify administration …
In a replication setup, a master MySQL server updates one or more slaves. Transactions are committed sequentially, and a slow transaction can cause the slave …
Mysql set up (“my.cnf”). The MySQL config file, my.cnf. Here is what to add under the [mysqld] heading. The two lines, “max_connections” and “max_user_connections” are …
If your MySQL connection is failing and returning the message ERROR 2002 (HY000): Can’t connect to local MySQL server through socket, then chances are your …
Use the following outline to connect and begin querying the MySQL server from within your PHP scripts. Connect to the MySQL server Use the following …
Here are a few initial things (common mistakes) to take a look at: – Make sure that after you created your database and database user …
The most common cause for this error, is a failed downgrade of MySQL from 4.1 to 4.0. Many changes were made between MySQL 3.x, 4.0.x, …
Syntax sp_fulltext_database Initializes full-text indexing or removes all full-text catalogs from the current database. sp_fulltext_database [@action =] ‘action’ Arguments [@action =] ‘action’ Is the action …
How to View a Table in a SQL Server Database Need to know how you can view a table within a SQL server database? Using …
This website uses cookies to ensure you get the best experience on our website. Please read our Privacy Policy.