Q: I don't know the MySQL root password. How can I reset it?

A: The root password was set in the Chapter 3 movie "Installing Ubuntu Server 12.04" at around the 2:24 mark.

If you are unable to log in with the root MySQL user, there are two common possibilities:  you may have set it to blank (no password), or you could have set it to something that isn't root.

1) SSH into the sandbox. From the command line, type the following:

mysql -uroot

2) If this doesn't work, then the password is set to something other than blank. Type:

mysql -uroot -proot

3) If this doesn't work, then the password is not root either and you'll need to reset it to something else. (If it does work, just type "exit;" without the quotes.)

Stop the MySQL server. Type:

sudo /etc/init.d/mysql stop

4) Start MySQL, but without permission checks. In a production environment, this can be a security vulnerability, but within this local context it's safe. Type:

sudo mysqld --skip-grant-tables &

5) Log in to the server. Type:

mysql -u root mysql

6) Set the password, let the new password take effect, and exit the console. Type:

UPDATE user SET Password=PASSWORD('root') WHERE User='root'; FLUSH PRIVILEGES; exit;

7) Restart the server normally. Type:

sudo /etc/init.d/mysql restart

8) Additional documentation regarding resetting permissions can be found at http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html.

Q: After upgrading VirtualBox, I received a message about USB 2.0 requiring the
 VirtualBox Extension Pack. What should I do?

A: You may receive the following message when attempting to start your virtual machine following an upgrade of VirtualBox:

"USB 2.0 is currently enabled for this virtual machine. However, this
 requires the Oracle VM VirtualBox Extension Pack to be installed."

Please install the Extension Pack from the VirtualBox download site. After
 this you will be able to re-enable USB 2.0. It will be disabled in the 
meantime unless you cancel the current settings changes."

You will need to disable the USB 2.0 Controller to avoid installing the Extension Pack. USB 2.0 is not required in this course.

1) From the Oracle VM VirtualBox Manager, select your VirtualBox, then click
 on the icon for Settings.
2) Under Ports -> USB, uncheck [ ] Enable USB 2.0 (EHCI) Controller.
3) Click OK.

Your environment should now start normally.

Q: After installing phpMyAdmin, I get a 404 "Not Found" error when trying
to access it. How can I repair it?

A: During installation, there was a prompt to choose a web server to
configure. Apache 2 should have been selected. If it was not, then you will
not be able to navigate to it. To reconfigure phpMyAdmin, execute the
following:

 

sudo dpkg-reconfigure -plow phpmyadmin

 

When prompted to choose a web server, choose Apache 2. For additional
details, see https://help.ubuntu.com/community/phpMyAdmin.

Q: When attempting to start the server, VirtualBox says, "VT-X/AMD-V
hardware acceleration has been enabled, but is not operational." How can I
proceed?

A: Not all processors have support for a 64-bit operating system;
 alternatively, you can start over using Ubuntu Server 12.04 LTS 32-bit.
 There will be no practical functional difference and the instructions in
the course will still work. You will have to download the 32-bit server
disk image from http://www.ubuntu.com/download/server to be able to proceed.

Q: I want to use the same version of VirtualBox that was used in the demonstration. Where can I find it?

A: The instructions in the course are currently forwards compatible with newer versions of VirtualBox. If you would like to download the exact
version used in the course, visit https://www.virtualbox.org/wiki/Download_Old_Builds_4_1.

Can’t find an answer?

If you still have a question about Up and Running with Linux for PHP Developers, let us know.

Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click submit.