E-topbiz.com - php scripts and cgi scripts shop!

  • Proud Php And Cgi Scripts Provider Since February 2003!

  • More Than 9000 Satisfied Customers Can't Be Wrong!

  • More Than 11000 Scripts Sold - Guaranteed Quality!

  • Fair $70 Value Free Bonus With Every Script Purchase!

  •  • 

 • Our Articles: MySQL And Databases

The use of text files to collect and store data or information is not always the best method to follow. In most cases and instances, it is much easier and more efficient to use databases to handle large information. It is always easier to get data from tabular form than mining and searching the data from text files. Therefore, databases prevail over flat text files. Getting info and displaying it on a web page is difficult with text files, but using MySQL makes it actually worth doing. Also, with the help of MySQL, it is possible to find specific records and retrieve more desired results according to one's desire.
  MySQL is such a database. There are many other types of databases also that are used up for data storage purposes and most of them use SQL or Structured Query Language to communicate with it. It uses commands like "CREATE TABLE" or "INSERT INTO" to run queries and do the execution on the database. Particularly in MySQL, the syntax or the command can look a little bit different than other database styles. Like for example, Oracle does not allow the ` character while in MySQL it is preferred to use this character in and around table names and column names.  
  These databases which we are talking about contain tables which have rows and columns in it. These rows and columns contain the data in tabular form making it easy for the user to interpret and put into execution. In other words, databases are actually spaces or areas that could be compared to folders which contain files called tables. In the tables there are rows, which is where the data is stored for usage purposes. Every table has columns defined when it is created. These columns specify what type of data will be stored in which column. Every row in the table follows the column's guidelines and therefore only a specific type of data can be entered into a specific column. Databases can hold more than one table and a table can hold more than one columns and rows. These can be many in numbers according to the type and quantity of information.  
  Some of the cool things that are allowed in MySQL are:
- One can create a database and a table
- One can insert data into a database
- One can retrieve data from a database
- Converts text-file version of our E-mail script
- Exports databases in various formats, including SQL, LaTeX, CSV for Excel, and so on
- Backup facilities
  Security of the MySQL data base is the most important thing! It should be the first thought that should come to a MySQL administrator's mind after he has finished creating a new database. Privilege tables in the MySQL database is about securing a database which has been accomplished and completed through modifications made to the tables found in the MySQL database. Here is a brief summary of exactly how the privilege tables are modified.  
  The default setting of the MySQL privileges are as follows:
* root can only login by localhost. No password - you need to set it immediately!
* Any other user can connect from any host in the CS department (Solaris only). No password.
* Only root can access the administrative database 'mysql' and create other databases than the test databases.
* No other user can access any databases.
  For example, suppose you want to write a program to manage a certain database. By default only root can create/access/drop any database. You need to set up a user with correct privileges: create a database and grant the user the access to it.  
  Suppose we want to set up a user 'class' for accessing databases with name 'classdb', we do the following:  
  shell> mysql -u root -p
mysql> grant all privileges on classdb.* to class identified by 'class_password';
mysql> flush privileges;
  If you want multiple databases, you can either set up different users for them or grant their privileges to the same user. You can also give one user access to multiple databases at one time or vice versa.  
  There are two methods known which are used to modify these privilege tables in the MySQL data base. The first uses specific statements like INSERT, UPDATE and DELETE. This method lost its value soon after the second way was introduced in which special commands like GRANT and REVOKE.  
  Once you have been connected to the MySQL server, simply getting connected doesn't work! Of, course there is much to do after this. It is quite posssible that a user might intend to work with a particular database and he wants to choose a database to work with. This can be done in one of the two ways listed below:  
  1) One can include the name of the database he intends to use along with the mysql connection command. For example, the command used to both connect to the MySQL server and select the mysql database is: %>mysql -w root -q mysql  
  2) Once connected, select the database using the use command, as follows: mysql>use mydatabase  
  Once executed, all queries not explicitly specifying a database name will be directed towards the hypothetical mydatabase database.  
  This was only a small chunk of information about the various aspects and jobs MySQL can do for you, so just keep on reading!  
  Written by Goran Kusnjer,
E-Topbiz.com owner 
  php scripts shop  
  Home Page  •  About Us  •  Sitemap  •  Our Articles  •  Terms Of Use/Privacy  •  Frequently Asked Questions  
  Our Partners:  TurnKeyPot.Com  
  •  All rights reserved © 2003-2014 E-topbiz.com  •  HTML Valid  •  CSS Vaild  
  php scripts shop