< 1 2 3 >   Sort: Date

What Are the Predefined User Accounts
What Are the Predefined User Accounts? - MySQL FAQs - Managing User Accounts and Access Privileges There is only one predefined user account called "root": "root" was created during the installation process. "root" has no password initially. You need to assign a new password as soon as you finishes ...
2007-05-10, 4725👍, 0💬

How To Check Server Status with "mysqladmin"
How To Check Server Status with "mysqladmin"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to check the server status by with "mysqladmin", you can following this tutorial example: >cd \mysql\bin >mysqladmin -u root status Uptime: 223 Threads: 1 Questions: 1 Slow queries:...
2007-05-11, 4712👍, 0💬

What Tools Available for Managing MySQL Server
What Tools Available for Managing MySQL Server? - MySQL FAQs - Administrator Tools for Managing MySQL Server MySQL comes with the following programs as administration tools for you to manage your MySQL server: mysqld - MySQL server daemon. You can use "mysqld" to start your MySQL server. mysqladmin ...
2007-05-11, 4706👍, 0💬

What Is "mysqlshow"
What Is "mysqlshow"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqlshow" is a command-line interface for end users to see information on tables and columns. Here are some sample commands supported by "mysqlshow": "mysqlshow" - Shows all the databases. "mysqlshow databaseName" - ...
2007-05-11, 4695👍, 0💬

How To Dump a Table to a File with "mysqldump"
How To Dump a Table to a File with "mysqldump"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to dump all rows in a table from the server to a file, you can use "mysqldump" with the "-f fileName" option as show in the following tutorial exercise: >cd \mysql\bin >mysqldump ...
2007-05-11, 4690👍, 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, 4679👍, 0💬

What Are the "mysqld" Command Line Options
What Are the "mysqld" Command Line Options? - MySQL FAQs - Server Daemon mysqld Administration "mysqld" offers a big list of command line options. Here are some commonly used options: "--help" - Displays a short help message on how to use "mysqld". "--verbose --help" - Displays a long help messages ...
2007-05-11, 4669👍, 0💬

What Is "mysqld"
What Is "mysqld"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqld" is MySQL server daemon program which runs quietly in background on your computer system. Invoking "mysqld" will start the MySQL server on your system. Terminating "mysqld" will shutdown the MySQL server. Here is ...
2007-05-11, 4667👍, 0💬

How To Load Data Files into Tables with "mysqlimport"
How To Load Data Files into Tables with "mysqlimport"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to load a data file directly into a table, you need to prepare the data file as one line per data row, and use tab character as the column delimiter. The data file name sho...
2007-05-11, 4659👍, 0💬

What Is the MySQL Server Daemon - mysqld
What Is the MySQL Server Daemon - mysqld? - MySQL FAQs - Server Daemon mysqld Administration "mysqld" is MySQL server daemon program which runs quietly in background on your computer system. Invoking "mysqld" will start the MySQL server on your system. Terminating "mysqld" will shutdown the MySQL se...
2007-05-11, 4652👍, 0💬

How To Change the Password for Your Own User Account
How To Change the Password for Your Own User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to change the password of your own user account, you should use your user account connect to the server "mysql" first. You should then use the "SET PASSWORD ..." command to c...
2007-05-10, 4652👍, 0💬

What Are the Non-Standard SQL Commands Supported by "mysql"
What Are the Non-Standard SQL Commands Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql There are many non-standard SQL commands that are supported by "mysql". Here is short list of some commonly used commands: "SHOW infoName" - Shows basic information of based on the speci...
2007-05-10, 4643👍, 0💬

How To Show All Tables with "mysql"
How To Show All Tables with "mysql"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to see all the tables in a database, you run the non-SQL command "SHOW TABLES" at the "mysql" prompt. See the following tutorial exercise for example: >cd \mysql\bin >mysql -u root test Welc...
2007-05-11, 4632👍, 0💬

How To Connect to MySQL Server on a Different Port
How To Connect to MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration If your MySQL server is listening on port number different than 3306, you need to specify "--port=portNumber" option to any client program that needs to connect to the server. The tutorial exercise...
2007-05-11, 4625👍, 0💬

How To Show Table Names with "mysqlshow"
How To Show Table Names with "mysqlshow"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to show table names with "mysqlshow", you need to specify a database name. The followings tutorial exercise shows you how to get all table names that match a pattern: If you want analyz...
2007-05-11, 4616👍, 0💬

How To Use "mysql" to Run SQL Statements
How To Use "mysql" to Run SQL Statements? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to run SQL statement to your server with "mysql", you need to start "mysql" and enter your SQL statement at the "mysql" prompt. Here is a good tutorial exercise that shows you how to ru...
2007-05-11, 4606👍, 0💬

How To Return Query Output in XML Format
How To Return Query Output in XML Format? - MySQL FAQs - Command-Line End User Interface mysql By default, "mysql" returns query output in text table format. If you want to receive query output in XML format, you need to use the "-X" command option. Here is a good tutorial exercise: >cd \mysql\bin >...
2007-05-10, 4592👍, 0💬

How To Test a New User Account and Password
How To Test a New User Account and Password? - MySQL FAQs - Managing User Accounts and Access Privileges If you have new user created with a password, you test it using "mysql" program with the "-u" and "-p" options. The following tutorial exercise shows you some interesting use cases of connecting ...
2007-05-10, 4587👍, 0💬

How To Return Query Output in HTML Format
How To Return Query Output in HTML Format? - MySQL FAQs - Command-Line End User Interface mysql By default, "mysql" returns query output in text table format. If you want to receive query output in HTML format, you need to use the "-H" command option. Here is a good tutorial exercise: >cd \mysql\bin...
2007-05-10, 4585👍, 0💬

What Is a User Account
What Is a User Account? - MySQL FAQs - Managing User Accounts and Access Privileges A user account is identified by a user name and defines the user's attributes, including the following: Password for connection authentication. User privileges, for examples: Shutdown_priv, Create_priv, Drop_priv, In...
2007-05-10, 4584👍, 0💬

What Is "mysql"
What Is "mysql"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysql" is a command-line interface for end users to manage user data objects. You can use "mysql" to run any standard SQL statements against the server. For example, you use the following SQL statements to manage tables a...
2007-05-11, 4570👍, 0💬

What Are User Privileges
What Are User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges MySQL offers many user privileges to control user accesses to different funtions and data objects. Here are some commonly used privileges: ALL - All privileges. CREATE - Allows the user to use CREATE TABLE commands...
2007-05-10, 4560👍, 0💬

What Is "mysqlimport"
What Is "mysqlimport"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqlimport" - A command-line interface for administrators or end users to load data files into tables program tool to load data into tables. Here is a sample commands supported by "mysqlimport": "mysqlimport databa...
2007-05-11, 4558👍, 0💬

What Is the Command Line End User Interface - mysql
What Is the Command Line End User Interface - mysql? - MySQL FAQs - Command-Line End User Interface mysql "mysql", official name is "MySQL monitor", is a command-line interface for end users to manage user data objects. "mysql" has the following main features: "mysql" is command line interface. It i...
2007-05-10, 4549👍, 0💬

< 1 2 3 >   Sort: Date