MySQL root password for XAMPP installation

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
iela
TestLink user
Posts: 2
Joined: Wed Dec 26, 2007 6:34 pm

MySQL root password for XAMPP installation

Post by iela »

Hi,

I just tried the XAMPP package in order to test if Testlink + Mantis is convenient and it is !

I am trying to complete the installation and to set my own passwords for every admin users.

I have suceeded in changing the default password for the admin users for Testlink (admin/admin), Mantis (administrator/root), but not for MySQL (root/???).

When reading the readme_en.txt file at the root installation directory, it seems the root user for MySQL does not have any password, but the mysqladmin.exe is complaining when I try to change it.

Does anyone know to what value the root password has been set for MySQL in the XAMPP package ?

Thank you for having read me so far and for your answer.

Regards,

Iela.
iela
TestLink user
Posts: 2
Joined: Wed Dec 26, 2007 6:34 pm

Re: MySQL root password for XAMPP installation of Testlink

Post by iela »

Hi,

The password was 'mysqlroot'. It is not in a readme file but it is in the 'INSTALL_DIR\htdocs\mantis\config_inc.php' file.

Regards,

Iela
francisl
Advanced user
Posts: 25
Joined: Thu Jan 17, 2008 6:27 am
Location: Australia

Username / password to xampp

Post by francisl »

I have download the xampp lite and set it up as per instructions in the "readme_first.txt". I start it as per instructions in "readme_en.txt" and arrived at the welcome page.

However, what are the username and passwords I could use for the following:
1. phpMyAdmin;
2. Webalizer;
3. Mantis;
4. Testlink.

Besides, how could I access the mySQL database with the "root/mysqlroot"? Please advise. Thank you.

Regards,
Francis
francisl
Advanced user
Posts: 25
Joined: Thu Jan 17, 2008 6:27 am
Location: Australia

Post by francisl »

I found the username/password for TestLink. Below is the list:

1. phpMyAdmin (???);
2. Webalizer (n/a);
3. Mantis (???);
4. TestLink (admin/admin)
5. MySQL (root/mysqlroot - but don't know how to access it).

Regards,
Francis
havlatm
Member of TestLink Community
Posts: 940
Joined: Mon Oct 31, 2005 1:24 am
Location: Czech

Post by havlatm »

Default mysql root is for localhost only ('root'@localhost). So you can use it for access on command line on the same server and for access from php pages on the same server.
You cannot use the account if you have web server on different machine.

You must define a new mysql account for remote access at first.
francisl
Advanced user
Posts: 25
Joined: Thu Jan 17, 2008 6:27 am
Location: Australia

Post by francisl »

I have download the xampplite package and installed on a Window XP machine. It starts with the "xampplite_start.exe". With the TestLink username and password, I can logon to TestLink. However, I cannot access the following included with the package because I cannot find the username and password:
1. phpMyAdmin page;
2. Mantis (assumed to be inside MySQL).

If I can't access these pages, I can't do what you suggested. Besides, it is a Windows machine, not a Linux or Unix machine. Please advise.

Regards,
Francis
havlatm
Member of TestLink Community
Posts: 940
Joined: Mon Oct 31, 2005 1:24 am
Location: Czech

Post by havlatm »

I'm not sure if phpmyadmin is a part of xamp lite. It's already configured if yes. So you can browse MySQL DB via your browser. There is not limitation by default.
You must manually configure phpmyadmin if you installed it later. You can just look it phpmyadmin documentation - it's not difficult.
francisl
Advanced user
Posts: 25
Joined: Thu Jan 17, 2008 6:27 am
Location: Australia

Post by francisl »

There is an option available for phpMyAdmin in xamp lite. However, when I select it, a logon window pop up. I tried all username and password I could find from documents, but none work.

I am not familiar with MySQL. Please advise how could I browse the DB from the browser.

Besides, I still need username and password for the Mantis included in the xamp lite package.
Post Reply