Abilio Caetano - Entrepreneur

ARTICULO ACTUALIZADO. Probado en OSX 10.9.2
———————————————–

No te preocupes, cambiar la clave de root de MySQL en OSX es bien facil, y no eres al primero que necesita hacerlo. … yo mientras escribo esto, lo estoy haciendo 😉

0.- Abre el terminal, y copia y pega los siguientes comandos.

1.- Para el servicio de MySQL

sudo /usr/local/mysql/support-files/mysql.server stop

2.- arrancalo de nuevo en safe mode

sudo /usr/local/mysql/support-files/mysql.server start –skip-grant-tables

3.- abre el cliente mysql

/usr/local/mysql/bin/mysql

4.- ahora aparecerá el prompt de mysql : mysql>  , y escribe en el:

FLUSH PRIVILEGES;

5.- pulsa enter y después

ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘mypasswordnuevo’;

6.- pulsa enter y Listo!!

Para comprobar si se ha cambiado correctamente puedes hacer lo siguiente:

sudo /usr/local/mysql/support-files/mysql.server stop
sudo /usr/local/mysql/support-files/mysql.server start
/usr/local/mysql/support-files/mysql -u root -p

y escribe mypasswordnuevo

SI NO TE HA FUNCIONADO, prueba los siguientes métodos alternativos.

Los mismos pasos de antes, pero sustituyendo el paso 5.- por el siguiente:

5.-

UPDATE mysql.user SET Password=’mypasswordnuevo’ WHERE User=’root’;
FLUSH PRIVILEGES;

Y si tampoco funciona, prueba lo siguiente en el paso 5.-

5.-

UPDATE mysql.user SET authentication_string = ‘mypasswordnuevo’
WHERE User = ‘root’ AND Host = ‘localhost’;
FLUSH PRIVILEGES;

si deseas manejar las bases de datos de forma visual, descargate phpmyadmin, lo pones en la carpeta de apache, abrelo en tu navegador, e introduce el usuario root y la clave que acabas de poner.

si te ha servido de ayuda, déjame un comentario abajo 😉

Fuentes:
https://stackoverflow.com/questions/6474775/setting-the-mysql-root-user-password-on-os-x
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

In this Article I will explain how I successfully migrated a forum from PHPbb to BBpress in 5 minutes. It was easiest than I ever thought. After migrating to BBpress I just add few lines of code in a template file of phpBB to make a clean SEO redirect to the new forum. All worked like charm.

Be careful: Why to move from phpBB to BBpress?

I supose you already spend some time taking this decision, but remember this quick comparison phpBB Vs BBpress:

«bbpress is SIMPLICITY», «PHPbb is POWERFUL».

if you want to migrate a small starting community from phpBB to BBpress, it’s OK, if you want to migrate a large big community, maybe users will not understand the lack of functionality they are used to have in your phpBB forum.

In my case, I did a migration of a phpBB forum to wordpress BBpress because it was a in the early days of the creation of a community, the simplicity benefit of bbpress, worpress blogging integration, and the flexibility to add and mould the website towards the needs of the future community.

The migration from phpBB to BBpress:

STEP 1.- Installation of bbpress (Skip if you already installed it):

• Install wordpress,
• settings–> permalinks –>select post name

settings to migrate phpbb to bbpress

• install bbpress
• settings–> forums –>configure as I show in the screenshot

migrate phpbb to bbpress: configure bbpress like this

STEP 2.- And the only one step to migrate from phpbb to bbpress is:

• then install the plugin «CMS2CMS PhpBb to WordPress migration» , and follow instructions. It’s that easy.

TIPS:
1.- choose a different URL for the new forum. for example, if you used /forum/ in phpBB, use /forums/ in bbpress
2.- don’t delete your phpBB forum.
3.- as an extra, in phpbb you could disable registration of new users, and add a message in the /styles/prosilver/template/overall_header.html   file.

Preserving the SEO after moving from PHPbb to BBpress

It’s very easy!!!

and this is very important, not only to avoid penalizations, but to correctly direct potential users that come from SERP results in google to the new forum and don’t loose or frustrate visitors after the phpBB to BBpress migration.

STEP 3.- SEO 301 redirect

Open/edit:
/styles/prosilver/template/overall_header.html

search for:

// Send vars to template
$template->assign_vars(array(
‘FORUM_ID’ => $forum_id,

and just above this lines add this piece of code:

##################################
$titleac = trim($topic_data[‘topic_title’]);
$relativeurl = str_replace(‘ ‘,’-‘,$titleac);
$relativeurl = strtolower($relativeurl);
header(«HTTP/1.1 301 Moved Permanently»);
header(«Location: http://www.YOURDOMAIN.com/forums/topic/».$relativeurl.»/»);
#####################################

Links:
Comparison from the bbpress comunity point of view: https://bbpress.org/forums/topic/bbpress-vs-phpbb/
If this tutorial mof moving phpBB to BBpress was useful for you, please just let me know with a comment