http://vpsbible.com/forums/forum/databases Setup Unmanaged VPS for Linux Noobs! en-US Tue, 22 May 2012 08:52:25 +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-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/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-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/wordpress-reinstall-error-establishing-connection-to-database#post-1395 Mon, 23 Aug 2010 21:12:34 +0000 Bob Builder 1395@http://vpsbible.com/forums/ <p>Have you decided to reinstall wordpress on one of your domains using a new database/user name? probably deleting the old one (in my case)? Only to get a database connection error during setup?</p> <p>Answer: restart php/xcache.</p> <p>I've figured out that in my case the problem (if you see it that way) is xcache doing its job, it remembers the old database connection on a per domain basis. So if your reinstalling wordpress on a domain with a different database/user name restart php/xcache just before you start. In my case:</p> <p>sudo /etc/init.d/php-fpm reload</p> <p>Hope this might reach others before loss of hair. :o) </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-1582 Fri, 15 Oct 2010 05:05:50 +0000 safinrox 1582@http://vpsbible.com/forums/ <p>As the title says.<br /> I followed this tutorial: <a href="http://vpsbible.com/php/compile-install-php-fpm-mysql-nginx/" rel="nofollow">http://vpsbible.com/php/compile-install-php-fpm-mysql-nginx/</a></p> <p>The issue is that every time there is a server reboot, i always end up with "mysql connection not established" and the mysql daemon is never running.</p> <p>Having to login as root and type start mysql. The question, shouldn't it automatically start after reboot since i believe the tutorial adds it to the initiation routine? </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-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/centos-mysql-cant-createwrite#post-2367 Sun, 03 Jul 2011 09:54:47 +0000 Søren Gjessing 2367@http://vpsbible.com/forums/ <p>Hello<br /> I have a huge issue on this error on mysql.<br /> Can't create/write to file '/tmp/#sql<br /> the full error message is<br /> Can't create/write to file '/tmp/#sql_4761_0.MYI' (Errcode: 30) </p> http://vpsbible.com/forums/topic/stackscript-manual-installation-neither-worked#post-1442 Wed, 08 Sep 2010 09:32:06 +0000 J Y 1442@http://vpsbible.com/forums/ <p>I'm plagued with this error: </p> <p><code>ERROR 2002 (HY000): Can&#039;t connect to local MySQL server through socket &#039;/var/run/mysqld/mysqld.sock&#039; (2)</code></p> <p>Took my time doing manual install of everything on the Ubuntu/Nginx guide...then finally decided to burn it down and restart with the script. Doesn't matter what I do. I get this error. </p> http://vpsbible.com/forums/topic/setup-wordpress-3-for-single-sites-on-lemp-error-error-1064-42000-at-line-1#post-2078 Mon, 14 Mar 2011 08:17:45 +0000 Duan Do 2078@http://vpsbible.com/forums/ <p>#<br /> #inc_scriptMySQLdb<br /> db="create database $WPDB;GRANT ALL PRIVILEGES ON $WPDB.* TO </p> <p>$WPDBUSER@localhost IDENTIFIED BY '$WPDBPASS';FLUSH PRIVILEGES;"<br /> mysql -u root -p$MYSQLPASSWORD -e "$db"</p> <p>problem</p> <p>Enter password:<br /> ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check </p> <p>the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1</p> <p>I'm trying to figure out what to do here; should I substitute the values of the variables in this code. Like put the user and password into the code.<br /> I did export the variables above where the Bible said to do it and thing worked so far up until this point.</p> <p>thanks. </p> http://vpsbible.com/forums/topic/how-do-you-make-a-database-server#post-2065 Sat, 12 Mar 2011 07:58:28 +0000 Ollie H 2065@http://vpsbible.com/forums/ <p>Hello everyone, I am going to setup a linode server(s) soon and I plan to have a blog, forum and a bunch of php scripts running. I've been recommended to have 2 servers, one web and database. This way I can scale whichever that needs more resources. </p> <p>Now, I've google'd this and there doesn't seem to be a guide to do this. How hard is this? I'm a bit of linux noob so I hope you can bear with me. I really do want to learn and optimize my website. </p> <p>Also, can I follow your tutorials, base off of one server, but later, buy another server and make that server a database server? This way I can follow all your steps and not worry that I have to restart anything if I add a database server. </p> <p>Thank you! </p> http://vpsbible.com/forums/topic/mariadb#post-2045 Fri, 04 Mar 2011 10:21:22 +0000 Ricardo Sanchez 2045@http://vpsbible.com/forums/ <p>What do you think about mariadb, is a good option? faster than mysql? its still free </p> http://vpsbible.com/forums/topic/mcrypt-doesnt-load#post-1704 Wed, 24 Nov 2010 15:43:55 +0000 Daniel 1704@http://vpsbible.com/forums/ <p>I ran Ubuntu Lucid Lite script and WordPress script, and the index at my site give a typical error message "Error establishing a database connection".</p> <p>I installed PHPMyAdmin but give me the message "no se pudo cargar la extensión mcrypt" ... </p> <p>Now I don't know how fix it. </p> http://vpsbible.com/forums/topic/small-typo-in-tut-create-or-bin-mysql-dbs-using-the-terminal#post-1915 Mon, 07 Feb 2011 18:23:23 +0000 aharown07 1915@http://vpsbible.com/forums/ <p>Don't want to sound nitpicky. These tutorials are easily worth four times what I paid... and are saving me weeks of research and trail &amp; error learning.</p> <p>That said, the tutorial here (<a href="http://vpsbible.com/databases/add-delete-db/" rel="nofollow">http://vpsbible.com/databases/add-delete-db/</a>) says to delete the db using the command:<br /> delete database db_name;</p> <p>You actually want to ..<br /> drop database db_name;</p> <p>At least in my install (lemp stack ubuntu 32 lite), "delete" will result in syntax error. </p> http://vpsbible.com/forums/topic/username-in-phpmyadmin-tutorial#post-1914 Mon, 07 Feb 2011 01:19:08 +0000 aharown07 1914@http://vpsbible.com/forums/ <p>Part of the phpmyadmin tutorial here (<a href="http://vpsbible.com/databases/phpmyadmin-nginx/" rel="nofollow">http://vpsbible.com/databases/phpmyadmin-nginx/</a>) has a step where you paste in code to create an nginx virtualserver for the phpmyadmin.</p> <p>The paste code contains two references to USERNAME in paths. On my first attempt, I overlooked these (though I got the mydomain.com references edited) and errored.<br /> The tut. doesn't say to replace these with your non root username, but I went ahead and did that. Seemed to work out OK.</p> <p>Assuming I did the right thing there, might be good to note that in the tutorial (Unless I missed it somehow) for us extremely wet behind ears noobs. </p> http://vpsbible.com/forums/topic/phpmyadmin-suhosen-warning-and-log-on#post-1897 Sat, 05 Feb 2011 05:04:02 +0000 aharown07 1897@http://vpsbible.com/forums/ <p>Got PHPmyAdmin installed per tutorial.<br /> Two things concern me:<br /> 1- am I supposed to have to logon as root?<br /> 2- there's a warning about suhosen... the PMA docs suggest editing a bunch of settings. Anybody know much about that? What's suhosen and can I just turn it off? ...or is it a better idea to do the tweaking the PMA docs recommend?</p> <p>Edit: oops... I see I was spelling it wrong: suhosin. Found some threads on it. Will read.<br /> But still have the root log on question </p> http://vpsbible.com/forums/topic/standalone-mysql-server-needs-tuning#post-1850 Sun, 23 Jan 2011 17:59:59 +0000 roottoor 1850@http://vpsbible.com/forums/ <p>Alright, this has been an adventure, especially since I am not really intelligent when it comes to the inner workings of these matters. I'm setting up two Linodes, one app server the other a sql server, which I will be running a small social network on. I've installed MySQL on my 512, but now I need to tune it for optimal performance as a standalone server. Looking at my.cnf is over my head, so can someone give me a sample config for MySQL or at least point me in the right direction for my specific resources? </p> http://vpsbible.com/forums/topic/sql-buddy-alternative-to-phpmyadmin#post-1634 Sun, 31 Oct 2010 23:58:44 +0000 Simon 1634@http://vpsbible.com/forums/ <p>Rather than installing PHPMyAdmin package, which also installs Apache, I've just discovered a nifty app called SQL Buddy. It's lightweight, fast, has a much cleaner interface, doesn't require installation, and so far seems to do everything I need it to.</p> <p>I've put it on a subdomain (sql.mydomain.com), then configured nginx to route all requests to that subdomain via https for completely secure login.</p> <p><a href='http://sqlbuddy.com'>sqlbuddy.com</a></p> <p>Curious if anyone else has experience/opinion about it? </p> http://vpsbible.com/forums/topic/os-commerce#post-1257 Thu, 29 Jul 2010 17:06:27 +0000 richard cliffe 1257@http://vpsbible.com/forums/ <p>Hi Olly</p> <p>I'm trying to install os commerce onto a site I wish to use, the info i have received from os commerce tells me to upload the folder required into my public folder, then to install by accesing the site. When I go to the domain i get the nginx error message 502 bad gateway. </p> <p>I was wondering if you know what files i need to edit to allow me to access this. what I've been told to access is: </p> <p>mydomain.com/catalog/install/index.php</p> <p>I really appreciate any help with this. Cheers Rich </p> http://vpsbible.com/forums/topic/why-grant-all-privileges-for-mysql-user-when-making-wordpress-db#post-1072 Wed, 23 Jun 2010 21:00:05 +0000 Christine Giglio 1072@http://vpsbible.com/forums/ <p>In the article:<br /> <a href="http://vpsbible.com/content-management/wordpress-subversion/" rel="nofollow">http://vpsbible.com/content-management/wordpress-subversion/</a></p> <p>under<br /> Create a MySQL Database for WordPress from the Command Line</p> <p>It says to create a user granting them all privileges (ie GLOBAL) which will give that user permission across all databases (am I correct?). Is there a specific reason this is done?</p> <p>I have been creating mine with restrictive rights meaning userA has almost full permissions (I uncheck Grant under Administration the rest privileges are checked) to only userAdatabase. Each database has it's own user that only has access to that single database.</p> <p>Am I doing it wrong? It hasn't caused trouble so far but will it in the future?<br /> Or is my setup the work of a paranoid person? ;-)</p> <p>Thank you for any advice/cookies in advance. </p> http://vpsbible.com/forums/topic/mysql_secure_installation-access-denied-for-user-rootlocalhost#post-704 Tue, 11 May 2010 00:55:23 +0000 Bob Builder 704@http://vpsbible.com/forums/ <p>Just thought I'd make a note here, when initially installing mysql server I used a (hardcore?) password, for example: 8mO\!&lt;a]3l6.&amp;D/Os-Bd#;eCnQ\lHI</p> <p>When it came to do 'mysql_secure_installation' it just wouldn't let me in, even when trying a different extreme password.</p> <p>Just re-did the whole thing with a stupid simple password like 'letmein' and bingo it works!</p> <p>I'm guessing mysql can't properly save certain characters in the password maybe?? If I find out more I'll post info here (less someone else beats me to it). </p> http://vpsbible.com/forums/topic/cannot-login-to-phpmyadmin#post-644 Mon, 03 May 2010 13:23:55 +0000 Geoffrey Eggins 644@http://vpsbible.com/forums/ <p>Hey everyone,<br /> I followed the tutorials on setting up phpmyadmin and now i can see the phpmyadmin login screen but cannot login as root. I just keep getting this message. </p> <p>#1045 - Access denied for user 'root'@'localhost' (using password: YES)</p> <p>I know what my root password is and I am typing it in correctly. Any ideas. </p> http://vpsbible.com/forums/topic/mysql-database-mysql-login-username-does-not-exist#post-198 Fri, 12 Mar 2010 11:46:34 +0000 Anonymous 198@http://vpsbible.com/forums/ <p>can't get either phpmyadmin or drupal 7 install page to show- just blank. when i go to validate the virtual server i get an error of</p> <p> MySQL database : MySQL login 'username' does not exist</p> <p>how can i correct this? i know it's something easy that i'm overlooking. let me know if you need more details. thx </p> http://vpsbible.com/forums/topic/cant-get-either-phpmyadmin-or-drupal-7-install-page-to-show-just-blank#post-231 Tue, 16 Mar 2010 18:55:54 +0000 Anonymous 231@http://vpsbible.com/forums/ <p>updated php to v5.3.2 and still nothing....can't see the update in any systems but confirmed it through putty and virtualmin so now it's back to the docs I guess...anyone have any suggestions? </p>