http://localhost/phpmyadmin is a part of localhost database administration software (phpmyadmin) url login address. You can enter the address from http://localhost/phpmyadmin or you can use the following terminal input tool (web-based viewer).
What is PhpMyAdmin and how to use ?PhpMyAdmin is a web database management software written by php script. Phpmyadmin also be used in database management and maintenance tasks as well as a powerful SQL queryer. Only way to run PhpMyAdmin is to pull these two programs from http://www.apache.org and http://www.mysql.com and install your machine. It can be difficult to set them up one by one by setting apache2triad, phptriad or easyphp so that you can set them all in batches and in a fixed layout. Anyway, after the installation is over, you can launch the Apache Web server to http: //localhost/phpmyadmin address. On the left side of the PMA's welcome screen is a list of the databases defined in the system, with the active operations in MySQL memory and the tasks performed at that time. The database operations in the left menu will only appear as test and MySQL for a newly installed MySQL installation. By clicking on the names of these databases on the left side, you can reach the tables screen in the database and at the same time the names of the tables under the database will appear on the left side. It is possible to see the answers to send queries via PMA from the database by means of the browser from PMA in the same way by writing SQL clauses in the text field located in the middle window.
CREATING DATABASE IN PMAIt is possible to perform all database operations from the interface of Pma's Web browser. In the database hierarchy, the topmost database contains tables and fields, respectively. To create a database on Pma, it is enough to write a database name on the Create new database line on the main screen of Pma . As a name, it is necessary to use a sheep starting with a letter (not a number). For example, the first database is created in the system by giving the name startdb as the name. The created database is located in the left menu in Pma. If MYSQL was newly installed in the system, the left menu will list the newly created database, then the MySQL and StartupDB databases.
CREATING TABLES IN PHPMYADMINThere are no tables under a newly created database. Once you have created the database, it will be ready to create the tables that will contain the information to be stored under the StartupDB database. The most important thing to know about table creation is that it can be stored and misuse of storage space.
In order to create a table in the Pma interface, all you need to do is to enter the name of the partition table that says Create new table on database start in the right menu and the name of the table space in the Fields line underneath , by selecting StartdbDB as the database name from the left menu
We can store the name, surname, e-mail and gender information from a form on a web page. To create a table named users, you can use the table name in Pma and the number 5 in the row of the field number the first tablon is created.
In the page that comes up on the screen, the properties that will be included in the 5 adtes field will be specified in the username table to be created. We will create 5 properties of the information to be stored in the field. In the user table we will create, we store four different information such as first name, last name, email and gender. The aim is to give a sequence number to each name and lineage so that it is easy to access the information later. The name of the first field is given by typing in the userid line of the first information field on the screen. The userid field is chosen to store a number in the INT for a number hold only of a user. By selecting the auto_increment feature from the Extra menu, each row inserted into the database is autotomatically created to create its own userid value.
Then, for the field where the web name information is stored, the name of the field name is selected as Varchar. On the same line, the length / set section is entered with! & As the maximum number of letters that the name information can take. Similarly, for the surname field, the field name and surname are set to varchar and the value 16 is entered. The e-mail addresses are stored in the Varchar field and the Length / Set field in the e-mail address field. If an email address contains more letters, the first 50 letters will be stored.
A specific field type is selected in the field where tabloda gender information will be stored. If desired, this field may be preferred as varchar as well as name, surname and e-mail information, but Enum type is more useful in terms of performance and storage characteristics. In order to prepare the field for storage of gender information, 'g' in the field name, 'e', 'k' in Lenght / Set section is selected by selecting Enum in the type line. The letters e and k in single quotes represent male and female genders.
When the Save key is pressed to create a table, a message is displayed on the screen indicating that the user table has been created, and SQL commands are required to create the same table. The same table can then be reconstructed using the following commands:
CREATE TABLE users (kullaniciid INT NOT NULL AUTO_INCREMENT, name VARCHAR (16) NOT NULL, name VARCHAR (16) not null, VARCHAR email (50) not null, gender ENUM ( 'e', 'k') not null, PRIMARY KEY (userid))
BROWSING AND MODIFYING TABLES IN PMA
After selecting the database name from the left menu that needs to be done to browse the databases via Pma or PHP, click on the Browse button next to the table name. If you want to browse the stored information in the user table that was previously entered as trial information, you can click on the Browse link and all the entered information can be displayed on the screen. There is a record entered on each line. The Edit and Delete bindings on the same row of these records are used in order to change and delete the information of that record. It is enough to click the Delete link to delete the record from the table. Click the Edit link to change the information for a contact.
SELECTION OF SOME INFORMATION IN THE TABLES IN PMA
If there are dozens of tables, it can sometimes be difficult to browse all of the areas together. Some areas that provide a certain condition have the Select property to be registered in Pma. After selecting the database name from the menu on the left side, the Select link next to each table name gives the user the ability to select some fields and list them according to a binary criterion. When the Select link is clicked, the topmost information box has the field names of the table. All or some of these names are selected by holding down the Control key and clicking. Then enter the desired criteria in the field name and Value lines at the bottom of the page. For example, in the previously created user table, the letter k is written on the gender line to select records with gender female, k. By clicking the Go button on the screen,
In some cases, it may be necessary to search for records that contain only a certain syllable. For example, you may need to search for users whose last name is suffixed.
In this case, the% sign is used in the operating system just like * wildcard in file searches. For records that begin with syllables as syllables, the% is written in the% syllable field for% records for all traversed syllables, and% syllabus for concurrent records. %% core% core% and% core layers.
BACKUP AND DELETE DATABASE IN PMA
Pma, with its powerful management features, allows you to retrieve the backup of the database in the system and to delete the databases. Selecting a database name from the left menu brings up a number of options for getting a backup of the database underneath the table names. Structure only, located under the View dump (schema) of database line, ensures that the database is backed up only as empty tables. It is useful when you need to move the ready-made database skeleton to another location, without having to retrieve the random entries in a database.
The Structure and data option is used to move all tables and fields in the database, along with the records within them, to another location. Once these options are selected, the Go key is pressed to populate the SQL backup screen required to move the records in the database to another database. To save the SQL backup to a file, select the Send option and press the Go button.
In cases where the database needs to be deleted, the Drop database link on the same screen should be used. When this link is clicked, the user will be prompted to delete the database. Drop operation should be used with caution, since the table in the database will cause all records to be deleted so that they can not be used again.
USING SQL COMMAND IN PMA
Pma allows master database users to use SQL. In the main page where the database information is located, the text in the center can be executed by writing the required SQL commands in the input field of the information. When SQL commands are entered incorrectly, MYSQL error messages can be displayed to the user via Pma. When it is desired to delete data using SQL, Pma will ask the user for confirmation to prevent data being erased as a result of an incorrect operation. Previously prepared SQL statements can also be called from an external file using the Browse key under the SQL run text field.
Using Pma it is possible to load database backups directly into the empty database using this feature.
The most important part we came up with!
Categories in the Table
Recognizing the need to create table space types and values can take ..
TINYINT [(M)] [UNSIGNED] [zerofill]
very small integer, normally takes values between -128 and 127. If defined as unsigned, that is to say positive, it can take values between 0 and 255. Fixed dictation occupies 1 byte
SMALLINT [(M)] [UNSIGNED] [ZEROFILL]
Small integer. Normally it is between -32768 and 32767. Unmarked or Unsigned value is between 0 and 65535. The hard disk occupies 2 bytes.
MEDIUMINT [(M)] [UNSIGNED] [ZEROFILL]
Integer in the middle value. Value range -8388608 and 8388607. Can be set between 0 and 16777215 without sign. The hard disk occupies 3 bytes.
INT [(M)] [UNSIGNED] [ZEROFILL]
Normal integer. The unspecified range of the defined range -2147483648 and 2147483647 is between 0 and 4294967295. The hard disk occupies 4 bytes.
BIGINT [(M)] [UNSIGNED] [ZEROFILL] The
large integer. The value range is -9223372036854775808 and 9223372036854775807. The unmarked range is 0 and 18446744073709551615. The hard disk occupies 8 bytes.
Reel number. 4 or 8 digits can be stored after the confirmation. It occupies 4 bytes on the hard disk
FLOAT [(M, D)]
Small real number. It can not be stored unmarked. Space occupies 4 bytes on the hard disk
DOUBLE PRECISION [(M, D)]
Normal real number. Hide without sign. It occupies 8 bytes on the hard disk.
REEL [(M, D)]
Normal real number. It can not be stored unmarked. The hard disk occupies 8 bytes. The double is the same.
DECIMAL [(M, D)] An
unpacked flowing number. It can not be unmarked. It has the same value range as Double. The hard disk takes up M + D bytes.
It stores the system time in the database. The hard disk occupies 4 bytes.
type of date storage.
time storage data type.
Used to store date and time information together.
VARCHAR (M) [binary]
Used to store text information with variable number of characters. For example, if the amount of information to be stored is 15 letters per 4, Varchar is more useful than Char. Up to 255 hard can be stored It is not considered that the letters or numbers stored in the search process are capital or small. If the table is created with the binary parameter, there is case-sensitivity. The amount of information stored on the hard disk occupies + 1 byte.
TINYTEXT and TINYBLOB
Variable amount of text or binary information. There is absolutely no difference between uppercase and lowercase letters. Up to 255 letters can be stored. The information stored in the hard disk occupies + 1 byte.
TEXT and BLOB
Variable amount of text or binary information. There is absolutely no capitalization. A maximum of 65535 letters can be accommodated. The amount of information stored on the hard disk occupies + 2 bytes.
MEDIUMTEXT and MEDIUMBLOB
Variable quantities of text or binary information. There is absolutely no difference between uppercase and lowercase letters. A maximum of 16777216 letters can be accommodated. The amount of information stored on the hard disk occupies + 3 bytes.
LONGTEXT and LONGBLOB
Variable amount of text or binary information (case insensitive, maximum 4294967295 letters can be stored, amount of information stored on the hard disk + 4 bytes)
ENUM ('value,' value1 ', ... )
It stores information that can not be right at the same time as the text. For example, people are born either as men or women. The enum type is useful for storing information that is not co-valued. Whatever the value, the hard disk occupies 1 or 2 bytes.
SET ('value,' value1 ', ...)
Similar to the enum type, but can take multiple values at the same time. For example, the front left wheel of a vehicle may have exploded, which may have exploded right behind the wheel. When there are known prior possibilities, the set types are used if more than one state occurs at the same time. It occupies 1 to 8 spaces on the hard disk.
PHPmyadmin Connection Info
|Web Browser:||CCBot/2.0 (http://commoncrawl.org/faq/)|
Local Hosting Server Folders & Ports
http://localhost:3000 - http://localhost:4200 - http://localhost:8000 - http://localhost:8080 - http://localhost:1745 - http://localhost:5774 -
127.1.1.1 - http://localhost/phpmyadmin - http://localhost/wordpress - http://localhost/wordpress/wp-admin - http://localhost/xampp - http://localhost/mysql -