This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
cms_faq [2011/06/24 06:59] siva_epari created |
cms_faq [2018/03/24 11:13] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | == - Reset Mysql password== | + | ==Links== |
+ | |||
+ | * [[cms1|Drupal, Day1]] | ||
+ | * [[cms2|Drupal, Day2]] | ||
+ | * [[cms_faq|Frequently Asked Questions, CMS]] | ||
+ | * [[drupal-lms|Library Management System as Assignment]] | ||
+ | |||
+ | ===Frequently Asked Questions(FAQ)=== | ||
+ | |||
+ | ==Reset Mysql password== | ||
/etc/init.d/mysql stop | /etc/init.d/mysql stop | ||
mysqld_safe –skip-grant-tables | mysqld_safe –skip-grant-tables | ||
- | ctrl + shift + t (For new tab in terminal) | + | |
+ | ctrl + shift + t (For new tab in terminal) | ||
mysql | mysql | ||
update mysql.users set Password=password('password') where User='root'; | update mysql.users set Password=password('password') where User='root'; | ||
Line 15: | 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 23: | Line 34: | ||
* open **Applications** > **Programming** > **Mysql query browser** present in Debian desktop menu | * open **Applications** > **Programming** > **Mysql query browser** present in Debian desktop menu | ||
+ | * 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 Desktop menu | ||
+ | * 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 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 38: | Line 85: | ||
==Unable to find php5-gd or any other debian packages== | ==Unable to find php5-gd or any other debian packages== | ||
- | * add “deb http://ftp.us.debian.org/debian testing main contrib non-free” to /etc/apt/sources.list and put **#** in front of all other lines present in the file | + | * add the following line to /etc/apt/sources.list |
+ | |||
+ | deb http://ftp.us.debian.org/debian testing main contrib non-free | ||
+ | |||
+ | put **#** in front of all other lines present in the file | ||
+ | |||
+ | apt-get update | ||
==Php5-gd error== | ==Php5-gd error== | ||
Line 82: | Line 135: | ||
* Get a dump of **d7** database from phpmyadmin or mysqladmin or command line as | * Get a dump of **d7** database from phpmyadmin or mysqladmin or command line as | ||
- | + | ||
mysqldump -uroot -ppassword d7 > /var/www/d7/mysql-dump.sql | mysqldump -uroot -ppassword d7 > /var/www/d7/mysql-dump.sql | ||
Line 99: | Line 152: | ||
* Check your system ip and put it in the configuration | * Check your system ip and put it in the configuration | ||
* Whenever anyone request the dynamic host name you created, the apache server will serve the local instances to the host name. | * Whenever anyone request the dynamic host name you created, the apache server will serve the local instances to the host name. | ||
+ | |||
+ | ==Links== | ||
+ | |||
+ | * [[cms1|Drupal, Day1]] | ||
+ | * [[cms2|Drupal, Day2]] | ||
+ | * [[cms_faq|Frequently Asked Questions, CMS]] | ||
+ | * [[drupal-lms|Library Management System as Assignment]] |