[SOLVED] MYSQL - how to tell what's going on ? (WordPress)
Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
Hi,
I followed a very clear pair of YouTube videos ([url]https://www.youtube.com/watch?v=eNpyEEW6No8[/url and https://www.youtube.com/watch?v=jUduv3_FY3c ]) on installing LAMP and WordPress. Thought I'd got it all right, but appear not to have as WordPress can't access the database.
I've looked up the error, it's quite common, but nothing I've tried works.
I'm not sure what the questions are to ask...
Does MYSQL need to be started explicitly?
Any command run starting MYSQL gets "ERROR 1045 (28000): Access denied for user... "
If I run MYSQLD (is this the server? what's the relationship with this & MYSQL?) I get a whole host of warnings (170313....)
Where do I fing MYSQL on my machine?
How can I tell if I successfully created a database?
Many thanks
Have you configured your wp-config.php file correctly/ That's the first place to check.
Rather than going into a long answer, I'm going to suggest that you read a recent LQ blog post of mine. Then you can come back with specific questions.
Frank,
Thanks for that.
I just installed LAMP, not XAMPP so not sure how similar they are - the locations of the components are different I think.
I have been using the WordPress help inter alia - I have spent a day and a half on this and end up with loads of not-quite-there tutorials/advice (eg from the WP Codex "Upload the WordPress files to the desired location on your web server": on a local machine (localhost) - where is that?) To a neophyte, that doesn't help much.
In your XAMPP thread
Step 1: Copy the website files -if you haven't yet got a website, is this what you unzip from the WP download? Do you copy & rename it to your site name?
Upload the WordPress files to the desired location on your web server": on a local machine (localhost) - where is that?)
If you are using Mint as the first youtube video is, the location is under the /var/www/html directory. If you move your files there, you should be able to access them from your web browser by entering localhost in the browser pointing to the file. I didn't watch the entire video link you posted so I don't know if it explains testing the various steps. Did you do that? That's all explained at the site below and although it is an Ubuntu site, everything in it should work the same on Mint. If you're not using Mint, you need to post which distribution and release you are using. If you can access your db from a terminal as you indicated above, you should be able to do it from the browser. I've not used WordPress so can't help with that.
Thanks Yancek, that's where I thought they would be, but nothing I have done worked so I began to doubt. I followed the videos to the letter, pausing & rewinding (they are very clear).
I just couldn't resolve it and uninstalled the LAMP stack & installed XAMPP to see if I had better luck. Nope - every single thing I have done has hiccupped or failed completely: XAMPP threw a bucketload of warnings & errors in installation and I don't think it installed correctly (eg I don't get the control panel as far as I can tell).
However, phpmyadmin worked in my browser & I have now managed to get to the "famous 5 minute installation" stage (after 2 1/2 days of pain)
In case it helps any other lost soul, in phpmyadmin, you either enter YOUR OWN password OR use the generated one - even though that is in a different section, it replaces the one you just typed in...
(this resolved my recent grief. Earlier LAMP/mysql problems I have no idea).
I have now managed to install WP but don't feel entirely certain how I got here.
Thanks Frank & Yancek for taking the time to answer - both answers made me scrutinise everything again, which in turn led to success.
Cheers.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.