Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql

Jan 21, 2007

I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:

Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?

View 1 Replies


ADVERTISEMENT

I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working

May 8, 2009

Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.

Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..

View 4 Replies View Related

MySQL Error : MySQL Server Has Gone Away

Dec 18, 2007

I keep getting this error :
MySQL Error : MySQL server has gone away

How do I fix it?

my.cnf contents

Quote:

[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500

[mysqld_safe]
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

View 5 Replies View Related

Installing Php On Server That Does Not Have Mysql Installed

Aug 7, 2008

I have two servers, one is web server, the other one is mysql server.

I am installing php on web server that does not have mysql installed.

when I do the follows:

./configure --prefix=/usr/local/webserver/php --with-config-file-path=/usr/local/webserver/php/etc --with-mysql=/usr/local/webserver/mysql --with-mysqli=/usr/local/webserver/mysql/bin/mysql_config --with-iconv-dir=/usr/local --with-freetype-dir --with-jpeg-dir --with-png-dir --with-zlib --with-libxml-dir=/usr --enable-xml --disable-debug --disable-rpath --enable-discard-path --enable-safe-mode --enable-bcmath --enable-shmop --enable-sysvsem --enable-inline-optimization --with-curl --with-curlwrappers --enable-mbregex --enable-fastcgi --enable-fpm --enable-force-cgi-redirect --enable-mbstring --with-mcrypt --with-gd --enable-gd-native-ttf --with-openssl --with-sendmail=/usr/sbin/sendmail

the script tells me error:

configure: error: Cannot find MySQL header files under /usr/local/webserver/mysql.
Note that the MySQL client library is not bundled anymore!

Because mysql installed on another physical server. so how may I fix the problem? can I configure php without "---with-mysql" and "--with-mysqli" parameters? I need my php could access remote mysql server.

View 3 Replies View Related

Plesk 12.x / Linux :: Multiple PHP Not Working With Installed MySQL

Dec 19, 2014

I've enabled one more php using this guide: [URL] .... but mysql is not working with the new php installation, how to get it working?

View 7 Replies View Related

Local Mysql Server Name, IP Or Localhost

Jun 29, 2007

I am using localhost as mysql server name on my config file. then, when I enter [url], the address will automatically change to[url]that obviously getting error. when I change the mysql server name from localhost to the server public IP, everything seems ok.

My sql is 4.1.x with php 4.4.7, is that any way I may use localhost instead of IP?

or is there any potential danger using IP?

View 2 Replies View Related

Can't Connect To Local MySQL Server Through Socket

Oct 6, 2007

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/thesymbi/public_html/includes/class_core.php on line 274

I get this around 50 times a day!
I am fed up!

View 14 Replies View Related

"Can't Connect To Local MySQL Server" + "IPS Driver Error"

Jun 4, 2007

During peak times (especially weekends) many of my site's users have been reporting intermittent 'IPS Driver Errors' in the forums and the following error in the coppermine gallery:

Quote:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)

(The forums and the gallery are the main parts of the site).

I'm assuming that the site is having problems handling the number of users trying to connect to SQL. I tried increasing the max_connections and max_user_connections settings in my.cnf but it doesn't seem to have made a significant difference.

What do I need to do to fix this? Would I need to upgrade my server specs or is it something to do with the server settings?

my server specs: AMD Dual/Dual Opteron 270 with 4GB RAM.

View 3 Replies View Related

Mysql.sock Gone And Mysql Restart Doesn't Create It

Jun 16, 2008

For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.

View 5 Replies View Related

How To Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only

Feb 11, 2008

I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.

Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.

how can I get these database files to fully work on a new server?

View 2 Replies View Related

Plesk Automation :: Local Server Visible When Adding New MySQL Database

Mar 27, 2014

Somehow when customers add a new MySQL database they can select a Local MySQL server. It turns out this is the MySQL instance running on the CP server, can I somehow hide this server from the list?

View 1 Replies View Related

Knowledge Of Mysql Exploit Or Mysql Injection?

Jan 17, 2008

Can someone recommended me some one with knowledge of mysql exploit or mysql injection, it seem to our VB forum have issue with database load..

View 5 Replies View Related

MySQL Monitor Shows MySQL As Offline When It's Not

Jan 15, 2007

I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.

Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.

The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).

The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.

Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?

View 11 Replies View Related

Can I Move /var/lib/mysql To /home/mysql

Apr 15, 2009

my /var partition is full,

im not sure if any files i can remove to get more free space on /var partition.

because there are more free space on /home,

i think if i can move all the /var/lib/mysql to /home/mysql,

if yes,howcan i move it and do any change,

can let the sql data do not lose,

andrun well in the feature ?

View 14 Replies View Related

Uninstall MySQL 3.23 And Install MySQL 5.0

Mar 28, 2007

I've rented a dedicated server that comes with Red Hat Enterprise Linux 4 and MySQL 3.23 but I need at least MySQL 4.1 or higher. My knowledge about GNU/Linux is very limited, so I've read some documents at mysql.com and now I think I have to follow these steps:

1. Uninstall MySQL 3.23 with this command line:
shell> rpm -e mysql-*.rpm

2. Install the server and client RPMs of MySQL 5.0:
shell> rpm -i MySQL-server-VERSION.i386.rpm
shell> rpm -i MySQL-client-VERSION.i386.rpm

View 2 Replies View Related

Easy To Upgrade From MySQL 4.1 To MySQL 5

Jun 13, 2007

I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues?

View 6 Replies View Related

MySQL Error

Jul 21, 2007

I have this error my site:

dbconn: mysql_connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

*dbconn: mysql_connect: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug*

View 4 Replies View Related

MySql Error

Mar 3, 2007

I recived this error message while testing my website registartions form and was wondering what to do with this and i think it should be permission to access to the database is not given to the user but this is my own account and im the admin and how come the access is denied?

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'alien'@'localhost' (using password: YES) in /home/seektran/public_html/db_connect.php on line 12
Error: Could not connect to database server. Please try again later.Access denied for user 'alien'@'localhost' (using password: YES)

View 5 Replies View Related

Mysql 'max_allowed_packet' Error

Jul 1, 2009

in phpMyadmin when trying to import a database from a file, i'm getting the error:

#1153 - Got a packet bigger than 'max_allowed_packet' bytes

The file I'm importing is only 7.08MB

I have tried setting the packet size in the shell as follows:

mysql> mysqld --max_allowed_packet=32M

I got no error or no confirmation either using this command, sorry I dont use shell commands much so I dont know if thats a problem or if it worked.

View 3 Replies View Related

Error When Restore Mysql

Jul 8, 2009

I have a new customer moving from another host. His account was terminated already, so just have backup file. When restoring his mysql database, I have this error

Quote:

Unable to restore database dbname.sql to agesuke_forum : ERROR at line 521 in file: '/backup/dbname.sql': Unknown command ''.

Googling shows error in version < 5.0.6 but we are using 5.1.35 already. Is there any idea to fix? This account will run on CentOS 5 - 64bits, FYI.

View 6 Replies View Related

MySQL Error : Out Of Memory

Nov 7, 2008

MySQL Error : Out of memory

I'm getting this very frequently today

MySQL Error : Out of memory (Needed 76760 bytes)
Error Number : 5
Request Date : Friday, November 7th 2008 @ 01:52:17 PM
Error Date : Friday, November 7th 2008 @ 01:52:18 PM
Script : [url]
Referrer : [url]
IP Address :
Username :
Classname : vB_Database
MySQL Version :

I have Mysql 5 installed, on a Centos/Cpanel box. Server has 4GB memory, server load is green/normal.

I already ran optimization on the database too.

It started happening yesterday, pretty much after I installed this hack:[url]

Quote:

[mysqld]
local-infile=0
datadir=/var/lib/mysql
skip-locking
skip-networking
safe-show-database
query_cache_limit=2M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=500
max_connections=500
interactive_timeout=10
wait_timeout=28800
connect_timeout=20
thread_cache_size=128
key_buffer=512M ## 128MB for every 1GB of RAM
join_buffer=8M
max_connect_errors=20
max_allowed_packet=32M
table_cache=1024
record_buffer=8M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_swedish_ci
[mysql.server]
user=mysql
old-passwords = 1
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=24M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout

View 6 Replies View Related

MySQL - Out Of Memory Error

Jul 22, 2007

Warning: mysql_connect() [function.mysql-connect]: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /home/user/public_html/includes/functions.php on line 423
Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

View 7 Replies View Related

PHP-MYSQL Error At Installation

Dec 12, 2007

Error: Missing Dependency: php = 4.3.9-3.22.9 is needed by package php-mysql

above is the error if i try to install php-mysql

tried several times:

yum install php-mysql

but i get the same error everytime
i am using Centos4 + PHP5 + mySQL5

View 7 Replies View Related

PhpMyAdmin + MySQL Error

Jan 30, 2007

MySQL 5.0.27
phpMyAdmin 2.5.0
Php ver 4.4.0
IIS6 Win2003 Web Edition - dedicated

I cannot work out what is going wrong here. I have been up all night trying to work it out!

Have installed MySQL + PHPmyAdmin no errors no problems. Log into phpmyadmin and look at a database but it will not show how many records are in the field nor what size the records are. It says records - unknown, size unknown

View 4 Replies View Related

MySQL Error Took Store Down

Sep 22, 2007

I've got a Fully Managed VPS hosting service running my sites and this morning I got the following error messages. My host says they do not monitor mySQL yet this error took my whole store down and kept it down for several hours until I noticed that. It's not a complaint, just asking your opinions on what this could be and what should i do about it etc.:

Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in /home/store/public_html/include/func/func.db.php on line 47

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/store/public_html/include/func/func.db.php on line 47
Sorry, the shop is inaccessible temporarily. Please try again later.

View 12 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved