Basic questions about One-Click Install WordPress on Ubuntu 12.10

October 8, 2013 12.8k views
blogs.ishank
By:
blogs.ishank
Hi, I am new to Digitalocean and VPS hosting. I am learning to setup and move data for my WordPress blog. I use both methods - first, setting up WordPress from starch ( I followed this tutorial - https://www.digitalocean.com/community/articles/how-to-install-wordpress-on-ubuntu-12-04). Second, using one-click install (I am following this tutorial- https://www.digitalocean.com/community/articles/one-click-install-wordpress-on-ubuntu-12-10-with-digitalocean) . The first method- setting WordPress from scratch, works perfectly well, but I am having trouble in one-click installation. First Question: When I use one-click to feature install WordPress on Ubuntu 12.10, it simply install WordPress, and left me unaware about details such as MySQL Database name, username and password for my newly installed WordPress blog. I also tried to access wp-config.php. file, but I was baffled after seeing that there no information was stored in the file-(https://dl.dropboxusercontent.com/u/13241857/wpconfig.PNG). Can you help me find these details ? Second Question: I am also trying to install PHPMyAdmin for database administration and importing old database. I used apt-get install -y phpmyadmin, and I can easily access PHPMyAdmin login page by navigating to http://IP/phpmyadmin ( https://dl.dropboxusercontent.com/u/13241857/phpmyadmin.PNG). But I don't have any idea about the login username and password. Where can I find these details ? Third Question (not much important): When I execute mysql, sometimes, I encountered this error message- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Yes). What cause this error message ? Any idea ? Note: Software I use - DigitalOcean Console, Putty and WinSCP. Your help is appreciated. Thanks Ishank
Log In to Comment
9 Answers
oliversimon October 8, 2013
hi Ishank,

login as root via SSH: "ssh root@x.x.x.x" then change your MySQL root password via "mysqladmin -u root password newpassword". You can now access mysql with "mysql -u root -p". To show a list of your databases, type "show databases;". A database called "wordpress" will show up, which is the wp database that was automatically set up for your one click blog. In your wp-config.php you may find its password at the very end of the file. The login username to your phpMyAdmin is root and the password is the one you just set.
Reply
pablo October 8, 2013
RE: Question 1

Unless the WordPress one-click install is comprised of Nginx w/caching, I would stay away from it (for performance reasons) and follow this tutorial, instead: How To Install Wordpress, Nginx, PHP, and Varnish on Ubuntu 12.04;

RE: Question 2

Check out How To Install phpMyAdmin on a LEMP server

RE: SCP

Make sure you're using SFTP and not SCP or (especially!) FTP.
How To Install Wordpress, Nginx, PHP, and Varnish on Ubuntu 12.04
by Etel Sverdlov
Varnish is an HTTP accelerator and a useful tool for speeding up a server, especially during a times when there is high traffic to a site. It works by redirecting visitors to static pages whenever possible and only drawing on the server itself if there is a need for an active process. This tutorial covers installing wordpress on a LEMP stack (with nginx instead of apache), and then installing varnish.
Reply
blogs.ishank October 8, 2013
Thanks Oliver for solving my problems. Now I've just one more question.

I am following this guide https://www.digitalocean.com/community/articles/how-to-import-and-export-databases-and-reset-a-root-password-in-mysql.

I've a database dump (file name= backup.sql) at my desktop. I created a new database ("newdb"). I want to import backup.sql (database dump) data into newdb database (destination database). I am using the following command which I believe need some modification so I can locate backup.sql file from desktop.

mysql -u [username] -p newdatabase < [database name].sql

Could you please tell me the correct command to locate path and import database from desktop.

Your help is appreciated.

Ishank


Reply
blogs.ishank October 8, 2013
Thanks Pablo for letting me know about Nginx performace issue.
Reply
oliversimon October 8, 2013
Hi Ishank,
to import your database first connect via SFTP and upload your db to the server, for instace to /root.

Then via SSH:
cd /root
mysql -u root -p newdb < backup.sql
Reply
bob.ellison October 10, 2013
There are no reason to stay away from apache vs nginx unless you have specific reasons, and that has nothing to do with your question.

Look in your wp-config.php, you did not scroll down far enough, the info is appended to the bottom of the file......
Reply
rvreugdenhil February 17, 2014
Hi Could anyone give me any direction on how to access mysql without this ERROR 28000?
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I've tried every tutorial but dont seem to be able to set a new password in the first place.

thanks

Reply
kamaln7 MOD February 17, 2014
Try resetting the root password: http://www.cyberciti.biz/tips/recover-mysql-root-password.html.
Reply
rvreugdenhil February 17, 2014
hi Kamal,

I tried that but got stuck in safemode. When trying to stop mysql, it gives me this:
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) utility, e.g. stop mysql
--> this occurs when trying to restart and stop mysql.

If im correct, the password is still unchanged and from the beginning i haven't had access to mysql. i'm using putty, shouldn't i set any permissions for the ip adress im trying to log on from? Perhaps i'm a bit ahead of my issue now but again, i tried everything, sure its a small setting in the config.

Reply
Have another answer? Share your knowledge.