http://vpsbible.com/forums/forum/databases Setup Unmanaged VPS for Linux Noobs! en-US Tue, 22 May 2012 08:51:57 +0000 http://bbpress.org/?v=1.0.2 q http://vpsbible.com/forums/search.php http://vpsbible.com/forums/topic/unable-to-import-database#post-2975 Wed, 09 May 2012 02:49:26 +0000 Stu Rader 2975@http://vpsbible.com/forums/ <p>Always tricky. Figured it out so only one db connection with individual users in each wordpress instance. Sometime I have to ask a question publicly so I force myself to answer it. </p> <p>mysql&gt; GRANT ALL PRIVILEGES ON yourDB.* TO gurudawn@localhost IDENTIFIED BY 'xYZvhz8(Xx=QF3620s';<br /> Query OK, 0 rows affected (0.00 sec)</p> <p>Change in wp-confiq.php and Bada bing:) </p> http://vpsbible.com/forums/topic/unable-to-import-database#post-2974 Wed, 09 May 2012 00:42:29 +0000 Stu Rader 2974@http://vpsbible.com/forums/ <p>If the post above is in the wrong spot, please delete/move if need be. sry </p> http://vpsbible.com/forums/topic/unable-to-import-database#post-2973 Wed, 09 May 2012 00:39:55 +0000 Stu Rader 2973@http://vpsbible.com/forums/ <p>So I love scanning the forums and found a lot of gold nuggets along the way, really appreciate the VPSBible Guv, cuz it really is just that. As things change slightly I have to review my security roadmap, and here's my biggest "to do" this summer:</p> <p>One one Linode 512 I have 8 wordpress instances, each set up successfully using the scripts from the Bible. One thing I overlooked.... is that on each and every install I used the same username and password for the databases so if using a phpmyadmin you can see every database with one login. I've found this to be a security hole and my question is simple. I understand I can change the username and password in wp-config. Of course I don't want to create 8 users on the machine. The "hole" is that there are plugins out there that are similar to phpmyadmin. So, if had a cohort with admin privileges he/she could install such a plugin and "see" ALL the db's. If I put a new password in wp-config, how do I also update the mysql password in the cli &lt;mysql&gt; and is this going to solve the issue? </p> http://vpsbible.com/forums/topic/cant-get-to-phpmyadmin-webpage#post-2963 Tue, 24 Apr 2012 13:48:22 +0000 the_guv 2963@http://vpsbible.com/forums/ <p>!LOL! Wulfeous ...</p> <p>That is odd.</p> <p>Your A record is the key, bin the C cos it's unnecessary ... your vhost file looks fine.</p> <p>I suppose the A record had been recorded at Cloudflare? (I kinda suspect this is an issue, else more likely a misunderstanding of some kind, on their server/settings.)</p> <p>Er, I suppose you added the symlink! You know:-</p> <p>ln -s /path1/pma/ /path2/pma</p> <p>SqlBuddy is very nice, yes.</p> <p>One thing, I'd strongly suggest adding SSL protection to this kind of thing, where you're flashing your database about "in plain text (yikkkkkeeeeessss!)"</p> <p>... Just a thought, there's a tut here somewhere. </p> http://vpsbible.com/forums/topic/cant-get-to-phpmyadmin-webpage#post-2957 Mon, 23 Apr 2012 01:34:23 +0000 Wulfeous 2957@http://vpsbible.com/forums/ <p>Still oddness. A different subdomain that I had setup alread, directs properly, and I was able to setup sqlbuddy on it, instead of phpmyadmin. It's not a bad replacement at all, actually. Worth checking out, if only for how simple it is to put into place and use.</p> <p>I'm just still unable to set up new subdomains. </p> http://vpsbible.com/forums/topic/cant-get-to-phpmyadmin-webpage#post-2955 Sat, 21 Apr 2012 23:57:01 +0000 Wulfeous 2955@http://vpsbible.com/forums/ <p>Pretty confused on this one. can't seem to find any similar problems to work an answer out of, either.</p> <p>I've followed the phpmyadmin install guide of guv's, and am having trouble getting to it's page so that I can see my DB's.<br /> On cloudflare's DNS settings, I have an (example) A type entry of phpma to subdomain to my ip address.<br /> (I also already attempted changing it to a cName type that is a subdomain to mySite.com to no avail)</p> <p>No matter how I put it into cloudflare, when i go to phpma.mySite.com it instantly redirects straight to mySite.com instead of going to the phpmyadmin login.</p> <p>I am using 11.04, and it seems that the directories are a little different from the guide, but I'm pretty sure that I've accounted for it.</p> <p>my 'etc/nginx/sites-available/phpma.mySite.com' :<br /> <pre><code>server { listen 80; server_name phpma.mySite.com; access_log /home/myUser/public_html/mySite.com/log/phpmyadmin.access.log; error_log /home/myUser/public_html/mySite.com/log/phpmyadmin.error.log; location / { root /usr/share/phpmyadmin; index index.php; } # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000 # location ~ \.php$ { fastcgi_pass 127.0.0.1:9000; fastcgi_index index.php; include /etc/nginx/fastcgi_params; fastcgi_param SCRIPT_FILENAME /usr/share/phpmyadmin/$fastcgi_script_name; } }</code></pre> <p>I really don't see why I'm being redirected to the main site. Any idea's? </p> http://vpsbible.com/forums/topic/percona-mysql#post-2849 Wed, 29 Feb 2012 20:36:12 +0000 the_guv 2849@http://vpsbible.com/forums/ <p>It's a damn exciting reworking of the traditional relational db and it doesn't rely on SQL query lingo, hence 'No'SQL. It's wrapped into many db solutions, say Mongo or, for Amazon's solution, Dynamo. </p> <p>I'll be adding it as an option here, frankly only when I understand it better cos it's not necessarily a better choice (MySQL can be used as NoSQL, is another option, they can be used together too, then there's more traditional stuff like Postgre as a relational alternative (MySQL is relational, huh)).</p> <p>... what is best will depend on your specific data requirement, this is the key.</p> <p>But on balance I'm still happy to wait ... the non-relational terrain is maturing fast now but few would have said that a year ago. </p> <p>As an aside, but potentially a very important one ... all this is just as well, IMHO, now Oracle bought MySQL, last year was it, or 2010 ... not sure I trust Larry Ellison with the world and his database! </p> http://vpsbible.com/forums/topic/percona-mysql#post-2845 Wed, 29 Feb 2012 16:15:39 +0000 Marcus West 2845@http://vpsbible.com/forums/ <p>They are considered Mysql experts....what is Nosql Olly, and have you used Amazons DynamoDB? </p> http://vpsbible.com/forums/topic/percona-mysql#post-2844 Wed, 29 Feb 2012 08:01:07 +0000 the_guv 2844@http://vpsbible.com/forums/ <p>no, just had a look tho, mysql consultants, look good. </p> <p>... &lt;bloomin'eck&gt;did you see their pricing?&lt;/bloomin'eck&gt; </p> http://vpsbible.com/forums/topic/percona-mysql#post-2843 Tue, 28 Feb 2012 15:45:50 +0000 shelley corbin 2843@http://vpsbible.com/forums/ <p>hey guv, have you ever heard of Percona MySQL and why people use it? i just ran across the name. </p> http://vpsbible.com/forums/topic/unable-to-import-database#post-2840 Tue, 28 Feb 2012 03:37:17 +0000 the_guv 2840@http://vpsbible.com/forums/ <p>hey Marcus ... this is actually quite a detailed topic but here's something to start you off:-</p> <p>You should have a unique, non-root user with a unique password (used nowhere else) to manage each db instance. In other words, you're throwing up fencing and, if hacked, there is damage limitation.</p> <p>Re the root user, you can change the name, which is sensible. Most importantly, the root user should have a unique password.</p> <p>There are some special character issues with db passwords but, for each, at least use something super-scrambled like "fN6zEHhedq2YPnUgtQjcaSqR".</p> <p>... that's 24-char, excessively paranoid perhaps but why not?</p> <p>** I'd recommend playing with a development MySQL install - say on a local virtual clone of your VPS - before adjusting your production db users, so as not to lock yourself out or have downtime. The commands are well-documented via the big G :) </p> http://vpsbible.com/forums/topic/unable-to-import-database#post-2827 Mon, 20 Feb 2012 16:09:54 +0000 Marcus West 2827@http://vpsbible.com/forums/ <p><a href="http://vpsbible.com/databases/export-mysql-db/" rel="nofollow">http://vpsbible.com/databases/export-mysql-db/</a></p> <p>I just followed your guide Olly, but had to use root rather than user. How do we make our Mysql database accessible to User, and is it important security wise? </p> http://vpsbible.com/forums/topic/unable-to-import-database#post-2780 Tue, 31 Jan 2012 14:28:16 +0000 perryb 2780@http://vpsbible.com/forums/ <p>OK so the problem was actually down to me pasting the command in rather than typing it into the terminal - hence the split and and the resulting error </p> http://vpsbible.com/forums/topic/unable-to-import-database#post-2779 Tue, 31 Jan 2012 13:26:05 +0000 perryb 2779@http://vpsbible.com/forums/ <p>I can log into mysql using:</p> <p><code>mysql -u root -p</code></p> <p>But if I try to import a database:</p> <pre><code>mysql -u root -p localhost example &lt; example.sql</code></pre> <p>I get kicked out with the following error (notice the split after 'root'):</p> <pre><code>$ mysql -u root ERROR 1045 (28000): Access denied for user &#039;root&#039;@&#039;localhost&#039; (using password: NO) $ -p exmple &lt; example.sql</code></pre> http://vpsbible.com/forums/topic/wordpress-reinstall-error-establishing-connection-to-database#post-2749 Wed, 28 Dec 2011 23:12:06 +0000 hanasazi 2749@http://vpsbible.com/forums/ <p>And terrified to restart ANYthing! </p> http://vpsbible.com/forums/topic/wordpress-reinstall-error-establishing-connection-to-database#post-2748 Wed, 28 Dec 2011 23:10:31 +0000 hanasazi 2748@http://vpsbible.com/forums/ <p>I'm having this problem and more! I'm a total noob to VPS and secure WP installations and losing hair by the minute with numerous re-installs. I got your book, Guv, WordPress Ultimate Security. And trying to catch up fast bc I'm working for a client and way behind schedule. I really need a hero right now, every instruction I try to implement results in database errors and/or 500 internal server errors. Can you, or someone, help me figure out what I'm doing wrong? host: ipower; unmanaged VPS with VHM and cPanel, RapidSSL Security Certificate. </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2690 Mon, 24 Oct 2011 23:38:23 +0000 Joe Crocetta 2690@http://vpsbible.com/forums/ <p>I think there's a log rotate tutorial on the site somewhere. </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2685 Sat, 22 Oct 2011 20:44:56 +0000 Dan Ahn 2685@http://vpsbible.com/forums/ <p>just installed phpmyadmin again and it works. could you just tell me how to limit access.log from getting too big? </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2684 Sat, 22 Oct 2011 20:42:24 +0000 Dan Ahn 2684@http://vpsbible.com/forums/ <p>guvnr, this happened again so I looked deeper, and I realized it was access.log that became 18gb every 3 months...that was why mysql wouldn't start.</p> <p>I happened to do this though. </p> <p>sudo apt-get remove mysql-server libapache2-mod-auth-mysql php5-mysql<br /> sudo apt-get autoremove<br /> sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql</p> <p>everything works now but my phpmyadmin link is broken. any idea how to fix that and how to limit access.log from getting too big?</p> <p>Thanks! </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2489 Sun, 07 Aug 2011 09:05:41 +0000 SuicideKings 2489@http://vpsbible.com/forums/ <p>I ran into this issue as well on 2 different installs. This worked for me to get it to kick up reliably after reboot:</p> <p>I edited /etc/init/mysql.conf and commented out this:</p> <pre><code>#start on (net-device-up # and local-filesystems # and runlevel [2345])</code></pre> <p>...and changed it to just this:</p> <p><code>start on runlevel [2345]</code></p> <p>Maybe an issue with some OpenVZ setups?...because that's what both problems happened on and just thinking about the network differences between the two platforms. With Xen though I haven't had a problem. </p> http://vpsbible.com/forums/topic/phpmyadmin-error#post-2474 Tue, 26 Jul 2011 04:39:57 +0000 Brian Stewart 2474@http://vpsbible.com/forums/ <p>Reinstalled phpmyadmin and its now giving #1045 Cannot log in to the MySQL server</p> <p>*Ninja Edit*</p> <p>Turns out I could log in as root as no ***** user existed I presumed the ***** user i set up during the intial stages of the vps would be the same. </p> http://vpsbible.com/forums/topic/phpmyadmin-error#post-2473 Tue, 26 Jul 2011 04:19:26 +0000 Brian Stewart 2473@http://vpsbible.com/forums/ <p><a href="http://img811.imageshack.us/img811/261/welp.jpg" rel="nofollow">http://img811.imageshack.us/img811/261/welp.jpg</a></p> <p>After using a stackscript and following the phpmyadmin tut Im getting the above error msg.</p> <p>Any Advice ? </p> http://vpsbible.com/forums/topic/no-input-file-specified-shown-at-phpmyadmindomaincom#post-2468 Sun, 24 Jul 2011 20:58:19 +0000 the_guv 2468@http://vpsbible.com/forums/ <p>big cheers mycol :) </p> http://vpsbible.com/forums/topic/no-input-file-specified-shown-at-phpmyadmindomaincom#post-2467 Sun, 24 Jul 2011 05:10:07 +0000 mycol 2467@http://vpsbible.com/forums/ <p># here it is if anyone cares</p> <p>server<br /> {<br /> server_name .mydomain.org;</p> <p> access_log /var/log/nginx/example.com.access.log;</p> <p> error_log /var/log/nginx/example.com.error.log;</p> <p> root /var/www/mydomain.org;</p> <p> index index.php index.html index.htm;</p> <p> # use fastcgi for all php files<br /> location ~ \.php$<br /> {<br /> fastcgi_pass 127.0.0.1:9000;<br /> fastcgi_index index.php;<br /> fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;<br /> include fastcgi_params;<br /> }</p> <p> # deny access to apache .htaccess files<br /> location ~ /\.ht<br /> {<br /> deny all;<br /> }<br /> } </p> http://vpsbible.com/forums/topic/no-input-file-specified-shown-at-phpmyadmindomaincom#post-2466 Sun, 24 Jul 2011 05:09:03 +0000 mycol 2466@http://vpsbible.com/forums/ <p>resolved. I ended up rebuilding the linode, lol. pretty sure it was a problem with php.ini pointing to a non-existing web root. </p> <p>Guv, the guide was going well until we got to the php-fpm/fastcgi section. The flow breaks down and on my inital go I got discombobulated. Ultimately I installed nginx via the repository they show on their main page. Then I used a very clean domain.conf in sites-available. So far so good! </p> http://vpsbible.com/forums/topic/no-input-file-specified-shown-at-phpmyadmindomaincom#post-2464 Sat, 23 Jul 2011 11:28:38 +0000 mycol 2464@http://vpsbible.com/forums/ <p>I should also mention I opted to have sites located at</p> <p>/home/public_html</p> <p>I did not use '/home/USERNAME/public_html</p> <p>Could this be adding to the problem? </p> http://vpsbible.com/forums/topic/no-input-file-specified-shown-at-phpmyadmindomaincom#post-2463 Sat, 23 Jul 2011 11:23:54 +0000 mycol 2463@http://vpsbible.com/forums/ <p>I followed the guide and got php-fpm working in my multisite arrangement. Websites came up but I was unable to access phpmyadmin.domain.com without the error "No input file specified". I went back and installed fastCGI but I'm still having problems. Any ideas? </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2457 Thu, 21 Jul 2011 13:21:19 +0000 the_guv 2457@http://vpsbible.com/forums/ <p>Dan, you could do that anyway .. it won't hurt but will ensure you have the correct startup entry for the mysql daemon. Then again, this is setup in the script.</p> <p>Otherwise, it may be that you have a corrupted db. I'd recommend you take steps, at least, to optimize it. </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2456 Thu, 21 Jul 2011 01:28:44 +0000 Dan Ahn 2456@http://vpsbible.com/forums/ <p>The thing is, everything works fine for like a month, and when the traffic peaks a little, the database just fails for some reason. Then it's unable to start it in any way.</p> <p>I couldn't afford to wait for your response so I ended up resetting the server all over, but service mysqld start doesn't work for sure.</p> <p>I'll take a note of your suggestion for the next possible crash. Thanks! </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2450 Wed, 20 Jul 2011 14:34:17 +0000 the_guv 2450@http://vpsbible.com/forums/ <p>Sounds like a socket issue Dan .. maybe just a missing symbolic link. First though:-</p> <p>service mysqld start</p> <p>??</p> <p>if not:-</p> <p>cd /var/lib/mysql/<br /> ln -s /var/run/mysqld/mysqld.sock mysql.sock</p> <p>Howzat? </p>