Access MySQL from the command line
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 …
Latest articles for category: Database
MySQL Cluster vs. Replication
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 …
Tune MySQL
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 …
What to Do if MySql.sock File is Missing
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 …
Connect to MySQL through PHP
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 …
“Cannot connect to the database” errors
Here are a few initial things (common mistakes) to take a look at: – Make sure that after you created your database and database user …
MySQL will not start, “MySQL File ‘/usr/share/mysql/charsets/?.conf’ not found” in error log.
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, …
Enable the full text indexing for a MSSQL database
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 …
View the Contents of a Table in a SQL Server Database Using Enterprise Manager
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 …
Connect to my MSSQL database via Enterprise Manager?
To connect to your MSSQL database using Enterprise Manager, please perform the following: 1. Bring up Enterprise Manager. 2. Go to menu “Action”->”New SQL Server …
Export the data from different tables in our shared SQL environment?
Using Enterprise Manager Expand SQL Server group Expand the server name Expand Databases Expand the database that you’ll be exporting data from Click on Tables …
Showing 45 - 55 of 90 articles