By blogsishank
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
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hi Could anyone give me any direction on how to access mysql without this ERROR 28000? <br>ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES) <br> <br>I’ve tried every tutorial but dont seem to be able to set a new password in the first place. <br> <br>thanks <br> <br>
Try resetting the root password: <a href=“http://www.cyberciti.biz/tips/recover-mysql-root-password.html”>http://www.cyberciti.biz/tips/recover-mysql-root-password.html</a>.
RE: Question 1 <br> <br>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: <a href=“https://www.digitalocean.com/community/articles/how-to-install-wordpress-nginx-php-and-varnish-on-ubuntu-12-04”>How To Install Wordpress, Nginx, PHP, and Varnish on Ubuntu 12.04</a>; <br> <br>RE: Question 2 <br> <br>Check out <a href=“https://www.digitalocean.com/community/articles/how-to-install-phpmyadmin-on-a-lemp-server”>How To Install phpMyAdmin on a LEMP server</a> <br> <br>RE: SCP <br> <br>Make sure you’re using SFTP and <b>not</b> SCP or (especially!) FTP.
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.