This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
cms_faq [2011/06/25 13:25] siva_epari |
cms_faq [2018/03/24 11:13] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ==Links== | ==Links== | ||
| - | *Content Management System | + | * [[cms1|Drupal, Day1]] |
| - | * [[cms1|Content Management System(Focus On Drupal), Day1]] | + | * [[cms2|Drupal, Day2]] |
| - | * [[cms2|Content Management System(Focus On Drupal), Day2]] | + | * [[cms_faq|Frequently Asked Questions, CMS]] |
| - | * [[cms_faq|Frequently Asked Questions, CMS]] | + | * [[drupal-lms|Library Management System as Assignment]] |
| ===Frequently Asked Questions(FAQ)=== | ===Frequently Asked Questions(FAQ)=== | ||
| Line 26: | Line 26: | ||
| mysql -u root -ppassword | mysql -u root -ppassword | ||
| - | update d7.users set pass=md5('password'), name='admin' where uid=1; | + | update d7.user set pass=md5('password'), name='admin' where uid=1; |
| exit | exit | ||
| Line 33: | Line 33: | ||
| apt-get install mysql-query-browser mysql-admin | apt-get install mysql-query-browser mysql-admin | ||
| - | * open **Applications** > **Programming** > **Mysql query browser** present in Debian desktop | + | * open **Applications** > **Programming** > **Mysql query browser** present in Debian desktop menu |
| - | menu | + | |
| - | + | ||
| * It Opens a Mysql query browser asking for | * It Opens a Mysql query browser asking for | ||
| - | Server hostname: Localhost | ||
| - | username : root | ||
| - | password : hello | ||
| - | now click on connect. | ||
| - | |||
| - | * Now the Mysql query browser will open, click on the Resultset 1,a plain text editor | ||
| - | appears on top of the Resultset 1. | ||
| - | |||
| - | * on this plain editor write a query "create database d7" then click on execute. | ||
| - | * open **Applications** > **Programming** > **Mysql Administrator** present in Debian | + | Server hostname: localhost |
| - | Desktop menu | + | |
| - | + | username : root | |
| + | |||
| + | password : hello | ||
| + | |||
| + | now click on connect. | ||
| + | |||
| + | * Now the Mysql query browser will open, click on the Resultset 1,a plain text editor appears on top of the Resultset 1. | ||
| + | * on this plain editor write a query "create database d7" then click on execute. | ||
| + | * open **Applications** > **Programming** > **Mysql Administrator** present in Debian Desktop menu | ||
| * It Opens a Mysql Administrator asking for | * It Opens a Mysql Administrator asking for | ||
| - | Server hostname: Localhost | ||
| - | username : root | ||
| - | password : hello | ||
| - | now click on connect. | ||
| - | |||
| - | * Now a Mysql Administrator will open click on the option "user administration" | ||
| - | when we click on it a page will appear on right click on the tab "new user" | ||
| - | and give the Login information i.e: | ||
| - | |||
| - | Mysql User: | ||
| - | New Password: | ||
| - | Confirm Password: | ||
| - | |||
| - | * Click "Schema Privileges" the second tab on the same page | ||
| - | * Here a page appears having the database which you created in Schema List click on the | + | Server hostname: Localhost |
| - | database you created | + | |
| - | + | ||
| - | * Then a List of Available Privileges will appear on right of that page,click on any one of | + | |
| - | the available privileges and press ctrl A now all the available privileges are selected | + | |
| - | now press the arrow **<--** | + | |
| - | + | ||
| - | * Now click on "Apply Changes" | + | |
| - | * Your Database is created you can use the Username and database name and password given here | + | username : root |
| - | in your drupal database. | + | |
| + | password : hello | ||
| + | |||
| + | now click on connect. | ||
| + | |||
| + | * Now a Mysql Administrator will open click on the option "user administration" when we click on it a page will appear on right click on the tab "new user" and give the Login information i.e: | ||
| + | |||
| + | Mysql User: | ||
| + | |||
| + | New Password: | ||
| + | |||
| + | Confirm Password: | ||
| + | |||
| + | * Click "Schema Privileges" the second tab on the same page | ||
| + | * Here a page appears having the database which you created in Schema List click on the database you created | ||
| + | * Then a List of Available Privileges will appear on right of that page,click on any one of the available privileges and press ctrl A now all the available privileges are selected now press the arrow **<--** | ||
| + | * Now click on "Apply Changes" | ||
| + | * Your Database is created you can use the Username and database name and password given here in your drupal database. | ||
| | | ||
| ==Check and kill the existing process on the standard port 80(Apache) and 3306(MySQL)== | ==Check and kill the existing process on the standard port 80(Apache) and 3306(MySQL)== | ||
| Line 162: | Line 155: | ||
| ==Links== | ==Links== | ||
| - | *Content Management System | + | * [[cms1|Drupal, Day1]] |
| - | * [[cms1|Content Management System(Focus On Drupal), Day1]] | + | * [[cms2|Drupal, Day2]] |
| - | * [[cms2|Content Management System(Focus On Drupal), Day2]] | + | * [[cms_faq|Frequently Asked Questions, CMS]] |
| - | * [[cms_faq|Frequently Asked Questions, CMS]] | + | * [[drupal-lms|Library Management System as Assignment]] |