<< < 4 5 6 7 8 9 10 11 12 13 > >>   Sort: Rank

How To Grant User Privileges at the Global Level
How To Grant User Privileges at the Global Level? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to grant a user privilege at the global level, you can use the "GRANT privilegeName ON *.* TO userName" command. The argument "*.*" in the command stands for all database and all...
2007-05-10, 4181👍, 0💬

How To Create a New Table Using the MEMORY Storage Engine
How To Create a New Table Using the MEMORY Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB MEMORY storage engine stores table data in computer system memory. This is good for creating temporary tables. MEMORY is not the default storage engine. You need to specify "ENGINE = MEM...
2007-05-10, 4227👍, 0💬

How To Create a New Table Using MyISAM Storage Engine
How To Create a New Table Using MyISAM Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB MyISAM storage engine is based on the ISAM (Indexed Sequential Access Method) concept, which was first developed at IBM to store and retrieve data on secondary storage systems like tapes. My...
2007-05-10, 4242👍, 0💬

Where Table Data Is Stored by the MyISAM Storage Engine
Where Table Data Is Stored by the MyISAM Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, each database will have its own subdirectory to store table data....
2007-05-10, 4232👍, 0💬

What Happens to MEMORY Tables When MySQL Server Is Stopped
What Happens to MEMORY Tables When MySQL Server Is Stopped? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB If you have data rows stored in a table with the MEMORY storage engine, and the MySQL server has been shutdown by the DBA, all data rows will be removed. But the table structure will re...
2007-05-10, 4199👍, 0💬

How To Get a List of Databases from MySQL Servers
How To Get a List of Databases from MySQL Servers? - MySQL FAQs - PHP Connections and Query Execution Once you got a MySQL server connection object successfully, you need to know what databases are available on the server and which database you should use to manage your tables and data. To get a lis...
2007-05-10, 4583👍, 0💬

How To Connect to MySQL Severs with User Accounts
How To Connect to MySQL Severs with User Accounts? - MySQL FAQs - PHP Connections and Query Execution If you want to connect a MySQL server with user account name and password, you need to call mysql_connect() with more parameters like this: $con = mysql_connect($server, $username, $password); If yo...
2007-05-10, 4440👍, 0💬

How Many Scope Levels Can User Privileges Apply
How Many Scope Levels Can User Privileges Apply? - MySQL FAQs - Managing User Accounts and Access Privileges MySQL supports 5 scope levels a user privilege can be granted: Global Level - A privilege granted at this level applies to all databases on the server. Privileges granted at the global level ...
2007-05-10, 4177👍, 0💬

How To Turn on mysql Extension on the PHP Engine
How To Turn on mysql Extension on the PHP Engine? - MySQL FAQs - PHP Connections and Query Execution The "mysql" API extension is provided as "php_mysql.dll" for Windows system. Your PHP binary download package should have "php_mysql.dll" included. No need for another download. But you need to check...
2007-05-10, 4422👍, 0💬

How To Rename an Existing User Account Name
How To Rename an Existing User Account Name? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to change the name of an existing user account, you can use the "RENAME USER oldName TO newName" command. The tutorial exercise below shows you how to do this: >cd \mysql\bin >mysql -...
2007-05-10, 4208👍, 0💬

How To Access MySQL Servers through Firewalls
How To Access MySQL Servers through Firewalls? - MySQL FAQs - PHP Connections and Query Execution If your MySQL server is provided by an Internet service company, connecting to the server from your local machine will not be so easy, because there are firewalls between your local machine and your MyS...
2007-05-10, 4518👍, 0💬

How To Get MySQL Statement Execution Errors
How To Get MySQL Statement Execution Errors? - MySQL FAQs - PHP Connections and Query Execution When you execute a MySQL statement with mysql_query(), and the statement failed, mysql_query() will return the Boolean value FALSE. This is good enough to tell that there is something wrong with that stat...
2007-05-10, 4280👍, 0💬

How To Fix the INSERT Command Denied Error
How To Fix the INSERT Command Denied Error? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts The reason for getting the "1142: INSERT command denied" error is that your user accound does not have the INSERT privilege on the table or database. To resolve this error, you need to ask...
2007-05-10, 4569👍, 0💬

How To Insert Data into an Existing Table
How To Insert Data into an Existing Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql ...
2007-05-10, 4405👍, 0💬

How To List All Existing User Accounts
How To List All Existing User Accounts? - MySQL FAQs - Managing User Accounts and Access Privileges MySQL stores all existing user accounts in a table called "mysql.user". If you want see all user accoutns, you can use the "SELECT" command as shown in the tutorial exercise below: >cd \mysql\bin >mys...
2007-05-10, 4475👍, 0💬

What Do You Need to Connect PHP to MySQL
What Do You Need to Connect PHP to MySQL? - MySQL FAQs - PHP Connections and Query Execution If you want to access MySQL database server in your PHP script, you need to make sure that a MySQL API module (extension) is installed and turned on in your PHP engine. PHP 5 now supports two MySQL API exten...
2007-05-10, 4263👍, 0💬

How To Close MySQL Connection Objects
How To Close MySQL Connection Objects? - MySQL FAQs - PHP Connections and Query Execution MySQL connection objects created with mysql_connect() calls should be closed as soon as you have finished all of your database access needs by calling mysql_close($con) function. This will reduce the consumptio...
2007-05-10, 4384👍, 0💬

Can You Select Someone Else Database
Can You Select Someone Else Database? - MySQL FAQs - PHP Connections and Query Execution If your MySQL server is provided by an Internet service company, they will provide you one database for your use only. There are many other databases on the server for other users. But your user account will hav...
2007-05-10, 4400👍, 0💬

How To Drop an Existing Database
How To Drop an Existing Database? - MySQL FAQs - PHP Connections and Query Execution If want to drop an existing database from the MySQL server, you can use the DROP DATABASE statement. Here is a good example of dropping an existing database: $con = mysql_connect('localhost:8888' ,'dev', 'iyf'); $sq...
2007-05-10, 4316👍, 0💬

How To Delete a User Account
How To Delete a User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to delete a user account, you can connect to the server as "root" and use the "DROP USER ..." command to delete a user account. The tutorial exercise below shows you a good example: >cd \mysql\bin >...
2007-05-10, 4594👍, 0💬

How To Install PHP on Windows
How To Install PHP on Windows? - MySQL FAQs - PHP Connections and Query Execution The best way to download and install PHP on Windows systems is to: Go to http://www.php.net, which is the official Web site for PHP. Download PHP binary version for Windows in ZIP format. Unzip the downloaded file into...
2007-05-10, 4171👍, 0💬

How To Create a New Database
How To Create a New Database? - MySQL FAQs - PHP Connections and Query Execution A database in a MySQL server is a logical container used to group tables and other data objects together as a unit. If you are a the administrator of the server, you can create a new databases using the CREATE DATABASE ...
2007-05-10, 4302👍, 0💬

How To View User Privileges
How To View User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges If a regular user wants to see his/her own granted privileges, he/she can use the "SHOW GRANTS" command. If the "root" user wants to see other user's granted privileges, he/she can use the "SHOW GRANTS FOR userN...
2007-05-10, 4484👍, 0💬

What Are Storage Engines
What Are Storage Engines? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB Storage engines are programs that are integrated into MySQL database management system to manage data tables. MySQL 5.0 supports the following major storage engines: MyISAM Storage Engine - MySQL default storage engine....
2007-05-10, 4386👍, 0💬

<< < 4 5 6 7 8 9 10 11 12 13 > >>   Sort: Rank