Felitaur Site
Offerings
|
|
Setting up MySQL
[Linux System Administration Homepage]
| Overview |
Goals:
Understand the role of a SQL server
Configure MySQL
Test Perl-DBI and PHP connectivity
Files/directories covered:
Commands:
mysql
mysql -u username -p
mysqladmin
mysqld
|
| Questions |
What types of databases will run on linux? What other types are there?
What are "transactions" in SQL? Why are they important?
Is there a GUI interface, similar to the one used in ACCESS, for UNIX
Databases?
What is SQL injection? Why is it something to be very worried about?
Why are databases so important to modern businesses?
|
| Activites |
- Get a table into the test database
- Get a php program to call that table
- Try out the following?:
# Not case sensitive
CREATE DATABASE [username];
# These are case sensitive! Must be exact!
GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE
ON [databasename].* TO [username]@'localhost'
IDENTIFIED BY '[password]';
|
| References |
This page last updated on:
|
|
|
