Databases and MySQL - Revision history

Alex: Removed Ubuntu support

2017-08-24T17:19:58Z

Removed Ubuntu support

Shane: categorizing

2013-02-24T23:26:34Z

categorizing

Shane: categorizing

2013-02-24T23:21:44Z

categorizing

Todd: /* Protecting against SQL Injection Attacks */

2011-10-08T22:21:42Z

Protecting against SQL Injection Attacks

Todd: /* Protecting against SQL Injection Attacks */

2011-10-08T22:21:24Z

Protecting against SQL Injection Attacks

Todd: /* Protecting against SQL Injection Attacks */

2011-10-08T22:21:01Z

Protecting against SQL Injection Attacks

Todd: /* Installing MySQL */

2011-10-06T16:11:56Z

Installing MySQL

Todd: /* Installing MySQL */

2011-10-06T16:10:52Z

Installing MySQL

Todd: /* Installing MySQL */

2011-10-06T16:09:34Z

Installing MySQL

Todd: /* Installing MySQL */

2011-10-06T16:09:13Z

Installing MySQL

@@ Line 424: / Line 424: @@
 =Other MySQL Information=
-The configuration file for mysql is  ''/etc/mysql/my.cnf''. It specifies mysql directories and other parameters.  For example, if you want to migrate all the data from one mysql server to another, it is sufficient to copy files from ''datadir'', which defaults to ''/var/lib/mysql'' from ''/etc/mysql/my.cnf'' on Ubuntu. Another interesting parameter is ''bind-address''. By default, it restricts the access to mysql to the localhost, so you will probably want to comment it out, thereby allowing access from any host.
+The configuration file for mysql is  ''/etc/mysql/my.cnf''. It specifies mysql directories and other parameters.  For example, if you want to migrate all the data from one mysql server to another, it is sufficient to copy files from ''datadir''. Another interesting parameter is ''bind-address''. By default, it restricts the access to mysql to the localhost, so you will probably want to comment it out, thereby allowing access from any host.
 ''mysqladmin'' is the official command line program to communicate with the server for management tasks related to the server.  Common tasks that can be handled by ''mysqladmin'' include flushing some mysql elements (such as tables, privileges etc.), kill mysql threads, restart, shutdown, or validate a client.  In order to use this command, you need to provide the root password selected when the mysql server was installed.
 [[Category:Obsolete Content]]

← Older revision		Revision as of 23:26, 24 February 2013
Line 428:		Line 428:
	''mysqladmin'' is the official command line program to communicate with the server for management tasks related to the server. Common tasks that can be handled by ''mysqladmin'' include flushing some mysql elements (such as tables, privileges etc.), kill mysql threads, restart, shutdown, or validate a client. In order to use this command, you need to provide the root password selected when the mysql server was installed.		''mysqladmin'' is the official command line program to communicate with the server for management tasks related to the server. Common tasks that can be handled by ''mysqladmin'' include flushing some mysql elements (such as tables, privileges etc.), kill mysql threads, restart, shutdown, or validate a client. In order to use this command, you need to provide the root password selected when the mysql server was installed.

−	[[Category:~~Former~~ Content]]	+	[[Category:Obsolete Content]]

← Older revision		Revision as of 23:21, 24 February 2013
Line 427:		Line 427:

	''mysqladmin'' is the official command line program to communicate with the server for management tasks related to the server. Common tasks that can be handled by ''mysqladmin'' include flushing some mysql elements (such as tables, privileges etc.), kill mysql threads, restart, shutdown, or validate a client. In order to use this command, you need to provide the root password selected when the mysql server was installed.		''mysqladmin'' is the official command line program to communicate with the server for management tasks related to the server. Common tasks that can be handled by ''mysqladmin'' include flushing some mysql elements (such as tables, privileges etc.), kill mysql threads, restart, shutdown, or validate a client. In order to use this command, you need to provide the root password selected when the mysql server was installed.
		+
		+	[[Category:Former Content]]

@@ Line 421: / Line 421: @@
 SQL injection attacks pose a major security risk to the security and integrity of your database if you do not protect from them.
-See [http://www.tizag.com/mysqlTutorial/mysql-php-sql-injection.php this] for a very helpful tutorials on protecting against SQL injection.
+See [http://www.tizag.com/mysqlTutorial/mysql-php-sql-injection.php this] for a very helpful tutorial on protecting against SQL injection.
 =Other MySQL Information=

@@ Line 421: / Line 421: @@
 SQL injection attacks pose a major security risk to the security and integrity of your database if you do not protect from them.
-See [http://www.tizag.com/mysqlTutorial/mysql-php-sql-injection.php this] or [http://www.learnphponline.com/security/sql-injection-prevention-mysql-php this] for very helpful tutorials on protecting against SQL injection.
+See [http://www.tizag.com/mysqlTutorial/mysql-php-sql-injection.php this] for a very helpful tutorials on protecting against SQL injection.
 =Other MySQL Information=

@@ Line 22: / Line 22: @@
 If you wish to install phpMyAdmin do the following:
-) Download the latest version of the software from [http://www.phpmyadmin.net/home_page/downloads.php here] I am using 3.4.5 in this example. Downloading the file with the .tar.gz extension is probably the easiest to install it on Amazon EC2.
+) Download the latest version of the software from [http://www.phpmyadmin.net/home_page/downloads.php here] I am using 3.4.5 in this example. Downloading the file with the .tar.gz extension is probably the easiest way to install it on Amazon EC2.
 ) Copy the file to your Amazon instance.
@@ Line 66: / Line 66: @@
 ) connect to myphpadmin/
- http://ec2-MY-INSTANCE-HERE.compute-1.amazonaws.com/phpmyadmin/
+http://ec2-MY-INSTANCE-HERE.compute-1.amazonaws.com/phpmyadmin/
 Login with a mysql root account that you have create (Not it is generally considered a good idea to create a separate phpadmin account to login to this webpage as well as use https to communicate with this wegpage) Ask Google for more information. Additional information can be found [http://wiki.phpmyadmin.net/pma/Quick_Install here]

@@ Line 27: / Line 27: @@
 For Mac/Linux/Cygwin users:
-  ''scp -i myAmazonKey.pem phpMyAdmin-3.4.5-all-languages.tar.gz  myUserName@myec2host.amazon.com:~/.''
+  scp -i myAmazonKey.pem phpMyAdmin-3.4.5-all-languages.tar.gz  myUserName@myec2host.amazon.com:~/.
@@ Line 35: / Line 35: @@
 ) Extract the software on the Amazon instance:
-  ''tar -xzvf phpMyAdmin-3.4.5-all-languages.tar.gz''
+  tar -xzvf phpMyAdmin-3.4.5-all-languages.tar.gz
 ) Rename the directory and set permissions
-  ''mv phpMyAdmin-3.4.5-all-languages  phpmyadmin''
+  mv phpMyAdmin-3.4.5-all-languages  phpmyadmin
-  ''sudo chown -R apache.apache phpmyadmin''
+  sudo chown -R apache.apache phpmyadmin
 ) Move the directory to /var/www/html
-  ''sudo mv phpmyadmin /var/www/html''
+  sudo mv phpmyadmin /var/www/html
 ) Delete the tar file and install additional packages
-  ''rm phpMyAdmin-3.4.5-all-languages.tar.gz''
+  rm phpMyAdmin-3.4.5-all-languages.tar.gz
-  ''sudo yum install php-mysql''
+  sudo yum install php-mysql
-  ''sudo yum install php-mcrypt''
+  sudo yum install php-mcrypt
 ) Setup permissions in phpmyadmin folder
   cd /var/www/html/phpmyadmin/
 ) Copy and edit the sample php config
   cp config.sample.inc.php config.inc.php
+ sudo vi config.inc.php
 Edit this line:
-$cfg['blowfish_secret'] = 'mySecretHere'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
+ $cfg['blowfish_secret'] = 'mySecretHere'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
 ) Restart apache service
-sudo service httpd restart
+ sudo service httpd restart
 ) connect to myphpadmin/
-http://ec2-MY-INSTANCE-HERE.compute-1.amazonaws.com/phpmyadmin/
+ http://ec2-MY-INSTANCE-HERE.compute-1.amazonaws.com/phpmyadmin/
-Additional information can be found [http://wiki.phpmyadmin.net/pma/Quick_Install here]
+Login with a mysql root account that you have create (Not it is generally considered a good idea to create a separate phpadmin account to login to this webpage as well as use https to communicate with this wegpage) Ask Google for more information. Additional information can be found [http://wiki.phpmyadmin.net/pma/Quick_Install here]
 =Using MySQL=