0
votes
0answers
16 views

Am I using this command correctly? Can't understand why I get the error I am getting. Myqsl - Centos 6

So, I am trying to connect to a database through mysql ssh, but whenever I run the command Connect postfix@127.0.0.1 on postfix It returns with: ERROR 2005 (HY000): Unknown MySQL server host 'on' ...
0
votes
2answers
36 views

Moving /tmp to a different mounted drive

I've mapped my MySQL datadir to a different (and bigger) disk with 900GB [root@web ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/xvda1 40G 24G 14G 64% / tmpfs ...
0
votes
0answers
27 views

Two rpms with the same prefix name on one repository

I am using CentOS, I have a local repository and I want to add mysql server and mysql cluster rpms on it so I added all required rpm and all dependencies. At client that added my repo list all rpm ...
0
votes
0answers
68 views

configure: error: invalid MySQL root directory

I've a problem installing sphinx with percona 5.6 on centos 6.4. I'm getting the following error while building from source: ...
0
votes
0answers
63 views

Centos 6 - Lighttpd/ 403 error on PHP files, and issues adding website

So, I do have PHP/MySQL and PHP-FPM installed, but when I try to access PHP files, I get a 403 forbidden error. I have been looking around Google quite a lot, and not finding anything that is solving ...
0
votes
0answers
12 views

error-> Could not update ICEautohrity file

error-> Could not update ICEautohrity file in my Cent OS operating system When i was unable to use my mysql database i stopped it and restarted the system. Then i got the error as error:- Could ...
0
votes
1answer
63 views

What would cause MySQL to not respond to connections on 127.0.0.1 but work fine using localhost?

having a strange issue on one of my CentOS servers. I've noticed MySQL randomly will not respond if I try to connect via 127.0.0.1 in my PHP script. Basically, 1 out of 20 requests or so will usually ...
-1
votes
2answers
211 views

cPanel MySQL 5.5 Server keeps crashing (lots of errors + warnings)

I have a dedicated server (not a VPS/VM) running x64 Centos 6.5 Final + cPanel. The machine has 16 GB memory. I run a game server on this server (which uses MySQL as the back-end for data store). I ...
0
votes
3answers
46 views

Setting up a local webserver using CentOS on VM

im new here, and basically new at setting up a webserver... now im already googling, and searching here in stackexchange on how to setup a webserver, they tend to direct me to a working server.. i ...
0
votes
1answer
71 views

How to ensure version 5.5.* for mysql with puppet?

How can i ensure that the latest patch version of 5.5 will be installed by the yum installer under CentOS? class { '::mysql::server': package_ensure => '5.5.*' }
1
vote
1answer
1k views

MySQL server 5.5 on CentOS 6.5 error: “mysqld: unrecognized service”

I am using CentOS 6.5. I installed MySQL Server 5.5 from a .rpm package (downloaded from the official MySQL site) using the default .rpm installer. I also installed MySQL Client package the same way. ...
1
vote
1answer
176 views

Centos 6 - Can't get out of safe mode

So I was going into safe mode from following a tut to fix the error Access denied for user 'root'@'localhost' (using password: NO) And I had issued the following command: mysqld_safe ...
0
votes
3answers
7k views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

So at first I was getting this error when trying to create databases for use in phpmyadmin. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I ...
0
votes
0answers
1k views

MySQL Daemon Failed to Start - centos 6

So not sure why I am getting such error. When I type: mysql I get: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I know that there should ...
0
votes
2answers
126 views

Where to retrieve MySQL Database Backup? Centos 6

Had taken a look at: Where Are Databases Located - MySQL File Location Didn't seem to help much. I used this for a single MySQLDatabase backup: ...
0
votes
1answer
161 views

How do I start mysqld with options

I need to start up mysqld with command line options as from here: http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_skip-grant-tables I normally do sudo service mysqld start, ...
0
votes
1answer
340 views

can Homebrew be used on a Centos computer

I just installed Centos 6.4 minimal on an old computer with an internet connection threw my iMac. Set it up as a development server. Installments required: Nginx, Apache, PHP-5, Mysql, Redis, Mongodb ...
1
vote
1answer
207 views

What will happen if my DB server runs out of disk space?

I'm seeing a huge difference of free disk space between df -h and du -sxh / I've understood in my question Resolving unix server disk space not adding up that du -sxh / is a better estimation as ...
2
votes
1answer
90 views

How can I reimage my virtual server to not have size caps to individual directories?

As a prenote, I am extremely new to networking in general, and my knowledge is very minimal, even for things you guys would consider basic. I will try my best to keep up with any advice you have to ...
0
votes
1answer
27 views

Possible problems that may occur in CENTOS? [closed]

I have developed an application on fedora 13 that works fine. The dependencies of this application are jre 1.6.0_26,tomcat webserver 6.0.18 and mysql 14.12 distrib 5.0.67.Now we need to extend the ...
0
votes
1answer
278 views

Connecting from win7 to VirtualBox/CentOS/MySQL

I am running VirtualBox 4.2.16 in Win7. There I have MySQL server in CentOS 6.4. Telnet from Win7 to CentOS is fine. mysql -u root -h 192.168.56.102 p in CentOS is fine. This is what I have in the ...
1
vote
0answers
249 views

Suggestions for finding performance bottleneck on LAMP server

I know this question has been asked a thousand times and I've read through a bunch of the answers, but haven't found one that really helped me. I've used top and I'm not swapping at all, I've got ...
8
votes
3answers
3k views

I can't open phpMyAdmin, get error 301 or 500

I've installed phpMyAdmin, but I can't open it on any browser: I get a 301 redirect(*) if I browse to http://localhost:8080/phpmyadmin. If I add a / to the end of the addres, I get a 500 error status ...
0
votes
0answers
784 views

“service mysqld start” is not working

I got this error message when I start mysql. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I just installed installed apache2 and mysql. ...
0
votes
1answer
209 views

installing MySQL 64 bit community edition on linux production server from an newbie

Currently i am having command sudo apt-get install libmysqlclient-dev mysql-server I don't know whether it's going to install 32 bit or 64 bit mysql. Currently i am looking command for installing ...
2
votes
1answer
2k views

Can't start MySQL - no space left on device

I am not able to start MySQL, on a CentOS 6 system. When I checked in the mysqllog the error I get is 121117 11:16:19 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' ...
0
votes
2answers
2k views

Is it possible to see what sql commands are being run on my CentOS machine?

I bought a program that runs on my CentOS machine. It's written in PHP. It uses a MYSQL database. One of the functions of the program is to register new users. It uses a SQL query to add the users. I ...
1
vote
1answer
3k views

How to install, mysql-workbench in CentOS6?

well. How to install mysql-workbench in CentOS6 i686? first, su -c 'yum install mysql-workbench-gpl-5.2.42-1fc15.i686.rpm' but --> Finished Dependency Resolution Error: Package: ...
0
votes
1answer
152 views

Centos: php-devel trashed mysql

Good morning. I'm on a CentOS machine, did a yum install php-devel Flat out saying this MySQL Daemon failed to start. Starting mysqld: [FAILED] which ...
1
vote
1answer
2k views

MySQL ERROR 2002 (HY000) on CentOS 5

I have problem with starting up mysql. When I type service mysql start All I got is ERROR 2002 (HY000): Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock' (2)** ...
0
votes
4answers
5k views

Failed dependencies errors while installing MySQL on CentOS Linux

I am trying to install MySQL on Linux. And it seems that I'm confused which MySQL package I should use for my particular Linux environment. My Linux Details: Linux 2.6.32-71.el6.x86_64 #1 SMP Fri ...
1
vote
1answer
4k views

Under ISPConfig 3 no account can login since resetting my MySQL root password

I am running ISPConfig 3 under CentOS and I had to manually reset my MySQL root account password yesterday. Since resetting the password I haven't been able to login to ISPConfig's web interface with ...
4
votes
1answer
1k views

I believe I've deleted MySQL root user, how do I recreate it?

I'm running ISPConfig on CentOS and I don't know how, but I don't seem to have a root mysql user. I can stop mysqld with /etc/init.d/mysqld stop Start it again and skip grant tables mysqld_safe ...
0
votes
1answer
3k views

How to change the default database for one user in MySQL

Though this might seem like a http://serverfault.com question at first glance I don't think it is. I have a mysql database on a server at work. Every time I log in to execute a query, I have to ...
0
votes
1answer
2k views

How do you Install php-mysql on CentOS

if i try to install php-mysql I get the following error... not sure how to recover from it to get MySQL and the PHP MySQL module up and running [12:51]~> yum install php-mysql Loaded plugins: ...
0
votes
1answer
1k views

Upgrade mysql on CentOS (from 5.0.77-4.el5_4.2 to 5.5.7) [closed]

I need to upgrade mysql on CentOS (from 5.0.77-4.el5_4.2 to 5.5.7). Please let me know the steps.
2
votes
4answers
4k views

How can I install mySQL on CentOS without being root/su?

I want to install mySQL on CentOS. I do not have a root account on that machine. How can I install mySQL on CentOS as a user, ie. without being root?