Reset Password Magento via SQL

It seems like the password must be typed and not copy/paste at least on the install part. good to know ;o)

The default login is : admin The default password is : 123123

If you are having troubles and want to reset it to a different password, just run at your sql database:

1. SELECT * FROM admin_user;

Then, find the username you want to modify in the listing provided - ‘admin’ in this example. Then, to update the password, type:

1. UPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin';

‘qX’ would be changed to whatever you want it to be and same goes for ‘password’

You can also do this in phpMyAdmin, find the admin_user field and choose MD5 when updating password.

If you want to add a new admin user, you must not only create a new entry in the table ‘admin_user’, but you also have to insert an entry in the table ‘admin_role’ which has to be associated with the user by the field ‘user_id’.

Bakup Restore e Permissoes MYSQL/MAGENTO

Backup Magento 

Compactar pasta

sudo tar -xcvf use.tar.gz html/


Restore Banco Magento ssh

ps: retirar o backup pelo admin do magento

sudo mysqldump -h 127.0.0.1 -u root -p BANCO > nome.sql


Comando para criar usuario no banco de dados.

CREATE USER 'heder'@'%' IDENTIFIED BY 'senha';

Comando para Atribuir banco ao usuario especifico.

GRANT all ON DB_BANCO.* TO "heder" WITH GRANT OPTION;

Alterar Senha Usuario

SET PASSWORD FOR heder = PASSWORD('novasenha');

Alterar Senha ROOT MYSQL

UPDATE user SET password=password('0000000000') WHERE user='root';

Exibir usuarios e hosts mysql

select user,host from mysql.user;

Remover Footer no page.xml

These links are created by the footer_links block. To remove them, open the app/design/frontend/base/default/layout/page.xml file and find the following line there: 

<block type="page/template_links" name="footer_links" as="footer_links" template="page/template/links.phtml"/>

and delete or comment it.

Don’t forget to make a backup copy of this file beforehand.

Botão Pinterest, facebook, twetter, quick contact

Extensions

pinterest

http://www.magentocommerce.com/magento-connect/pin-interest-6744.html

http://connect20.magentocommerce.com/community/Interactone_Pinit

http://store.interactone.com/pin-it-install


depois de instalar add code

<?php echo $this->getLayout()->createBlock('core/template')->setTemplate('interactone/pinit.phtml')->toHtml(); ?>

se tiver magento easy tabs procurar pasta /usr/share/nginx/html/app/design/frontend/default/TEMA/template/easytabs

e adicionar codigo no catalogproductview.phtml


----

facebook

Inserir no mesmo arquivo acima o codigo

<div id="fb-root"></div><script src="http://connect.facebook.net/pt_BR/all.js#xfbml=1"></script><fb:like href="" send="true" layout="button_count" width="450" show_faces="false" font=""></fb:like>

------

twetter

Quick Contact

http://www.magentocommerce.com/magento-connect/freequickcontact-mageworld.html

usar versão 1.9

arquivos de tradução /usr/share/nginx/html/app/design/frontend/default/thema/template/quickcontact

How to Disable flash uploader Magento

How to Disable flash uploader Magento

Tired of that the buggy flash uploader in Magento ?

Do you want just a simple HTML form to upload your pictures and to know how to disable flash uploader Magento?

Be wise, install this plugin and all your troubles are gone away !

http://www.magentocommerce.com/magento-connect/Tobias+Renger/extension/1756/no-flash-uploader

Key for connect 2.0

If you want to save time you can use the following key in Magento Connect to install the plugin directly :

• http://connect20.magentocommerce.com/community/Dull_Uploader

Why disable the flash uploader?

The uploader relays on Flash Player, that might not be available if you are posting from a computer that isn’t yours. Moreover, is well known that sometimes can cause strange errors very difficult to debug, causing you spending lot of time to fix the upload of images!

Enjoy it !

Reiniciar Mysql CentOS

Reiniciar  Mysql CentOS


sudo /etc/init.d/mysqld

 sudo /etc/init.d/mysqld {start|stop|status|restart|condrestart|try-restart|reload|force-reload}


ou


sudo service mysqld {start|stop|status|restart|condrestart|try-restart|reload|force-reload}