Posts that Al is monitoring

Topic: mysql admin password change

So, phpmyadmin is not something you (Bitnami – er, are you with Bitnami?) created, but a separate application like mediawiki, used to manage databases etc?

Yes, I’m a proud member of the BitNami Team :) and no, PhpMyAdmin is not something we have developed. Its web site is located at http://www.phpmyadmin.net/

Cheers!

Topic: mysql admin password change

Hi Al,

I’m afraid I have no idea on how to export to pdf, nor the exact use of phpmyadmin, that’s something you will have to ask at the MediaWiki forums. I think it would be safe to delete the old user, and by mediawiki\_bitnami I really meant that, at least that’s what I selected in a listbox.

Cheers

Topic: mysql admin password change

How to export/import

Enter once again to phpmyadmin. There, you can find an ‘Export’ link, go click it. Select the ‘mediawiki_bitnami’ database, check ‘Save to file’ and click ‘Go’. You will be asked to choose a place to store the database file. Now you can safely uninstall and reinstall everything.

To import the database after installing MediaWiki, go to the phpmyadmin tool (again :D) and select ‘Import’. Then, simply browse for your file and cilck ‘Go’. After that, you will have to create the database user again, the same way that I explained you in the previous post.

Cheers

Topic: mysql admin password change

To change the database user name and password, you will have to accomplish two different tasks: the easiest, change $wgDBuser and $wgDBpassword to your preferred values in ‘LocalSettings.php’.
Now, you will have to modify the values in the database itself, so go to the phpMyAdmin tool web page, and click over ‘Privileges’. There, add a new user (just username and password, don’t care about the other fields). After that, you will be taken to another page in where you can give privileges for a specific database. Choose mediawiki\_bitnami and in the next page, check all privileges.

That would do it, I’ll answer to your other question in a while :)

Topic: mysql admin password change

First of all, let’s clarify some points :)

• Web server: A computer program that is responsible for accepting HTTP requests from clients, which are known as web browsers, and serving them HTTP responses along with optional data contents, which usually are web pages such as HTML documents and linked objects (images, etc.). Apache is a web server

• Database Management System: A ‘database management system’ (DBMS) is computer software designed for the purpose of managing databases based on a variety of data models. MySQL is one example of this.

• Dynamic web page: Classical hypertext navigation occurs among “static” documents, and, for web users, this experience is reproduced using static web pages. However, web navigation can also provide an interactive experience that is termed “dynamic”. Content (text, images, form fields, etc.) on a web page can change, in response to different contexts or conditions. PHP (PHP: Hypertext Preprocessor) is a computer scripting language originally designed for producing dynamic web pages.

You can find this all information, and a lot more, at the Wikipedia

1) More or less, yes.

2,3) Right.

4) MySQL is a program to create, control and query databases. Have a look at http://en.wikipedia.org/wiki/Database

5) Yes. The ‘root’ user is the administrator, he can do anything he wants to any database. Apart from that, you can (and should, because it’s more secure) setup other user(s) and give some permissions to them (for example, modify the contents of a certain database, but not be able to delete it). In a BitNami installation a root user is created (with the password you enter), and so another user is created only to be able to control the database. This user is the one who is configured in the ‘LocalSettings.php’ file to use the database.

Which of those two allows me to read unencrypted the mysql database and what would I need to do to login (using the tools provided during the installation of bitnami presumably)?

Both of them can. It’s adviced to use the bitnami user instead of the root one, because that way you only can modify the mediawiki database and it’s impossible to mess mysql configuration up :) There’s an utility called PhpMyAdmin used to control the database through a web page. You can use it by entering http://localhost/phpmyadmin You will be asked for a password, also set at installation time. Bear in mind that installing phpmyadmin is optional during installation, so maybe you didn’t install it.

6) More or less, yes.

Answering your questions:

- Yes, this is set at installation time.

- The username is root.

- Yes, but you can also log in as ‘root’.

- As I said, PhpMyAdmin is a web application (like MediaWiki is) used to control the databases.

Cheers,
Antonio

Topic: mysql admin password change

Hi Al,

What would you like exactly to change? The MediaWiki application admin password, the MySQL root password or the MySQL database user password? The first one is used to login to MediaWiki, and is set at installation time. The second one is used to control the MySQL server, and is the same password than the previous one. The third one is a standard password, and is used by the php application (MediaWiki) to change values in the mediawiki database. The database user (not root) can’t control other databases than the MediaWiki one.

I hope this all makes sense to you :)