I'm missing some features only available from MySQL 5.5.6 and therefore neither Debian's archive or dotdeb supports my needs Is it difficult (link / guide) to compile MySQL myself from my Mac or virtual debian and then distribute it to my servers, will it likely cause more problems and will I be able to compile upgrades later or change back to Debian archive (or dotdeb) when they are releasing a sufficient version? I've been administrating my servers for 2 years now and have some knowledge how things is working :-)
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code: the-matrix:~ # mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or Code: the-matrix:~ # rcmysql start Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[ [root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp [root@localhost ~]# /etc/init.d/mysqld start Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
I'm having a hard time getting part of Asterisk (the open source PBX) called asterisk-addons to compile with mysql CDR support which I need to enable Realtime I believe. I've spent the whole day trying to fault find this one (including thinking I had ruined my box and creating a new CentOS build!) and am pretty worn outWhen I attempt to install asterisk-addons (I've tried 1.6.0.1, 1.6.0.1-patch and 1.6.1.0-rc3), I get the following line in a ./configure:
checking for mysql_config... /usr/bin/mysql_config checking for mysql_init in -lmysqlclient... no Then when I do a make menuselect, MySQL is not selectable and XXX"d out: [code]....
I installed LaMp 2 days ago. First everything works; But until yesterday, I can't start anymore mysql server : it failed each time.
When I look at the status :
Code: Select allsystemctl status mysql Failed to get D-Bus connection: Erreur inconnue -1
It's like it can't generate mysqld.sock
Code: Select all/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
I keep reading man and trying to find something I didn't configure correctly, but I can't find nothing.
I have machine which manages all mail accounts and their traffic and as well mysql database and some more stuff. Theres also windows server where users are managed and they get their programs from over rdp. I have login screen on Linux machine. It says Debian GNU/Linux 5.0. And I have root password, but I know that I have to login first with simple user account after which I can access login as root. But where can I get simple user account info. I need to manage mailaccounts mainly there.
I have been fighting with this for days. I upgraded from etch to lenny. I tried installing mysql-5.1. I have uninstalled, reinstalled, updated, upgraded, many, *many*, times. It just stubbornly refuses to work.
Since upgrading from Wheezy to Jessie I have not been able to start the MySQL-server. When I do a "systemctl start mysql" I get the following answer on the console:
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details. Entering 'systemctl status mysql.service' the answer is: ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: loaded (/etc/init.d/mysql) Active: failed (Result: exit-code) since Don 2015-06-18 18:35:41 CEST; 4min 1s ago Process: 11272 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
syslog and hostname.err don't show any pertinent messages.
At the moment I am having a problem with the MySQL server on my VPS. It's a completely fresh install of both Debian 5 and MySQL but the problem is upon logging in I get:
[root@boris ~]#mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Been working with this problem for over a week now and has come to a dead end, I have installed pureFTPD with MySQL on Debian 5 Lenny 64bit. My problem is I can't login with the users in the sql-database, but for some strange reason, I'm allowed to loggin as anonymous. Unix users can't login either.
I have followed the guide on: [URL]..
- Created a ftpgroup and ftpuser. - Created a database ftpd - Created a user vhosts and given access to ftpd db My configurations files /etc/pure-ftpd/auth/30mysql Code: /etc/pure-ftpd/db/mysql.conf /etc/pure-ftpd/db/mysql.conf
I need to create a sandbox environment on my LAMP server for PHP/MySql development. Anyone who could point me in the right direction or share their insight?
I have been tearing my hair out with this. As part of a backend perl script i am holding the Epoch time as session data using apache session and mysql so i can delete sessions after an expiry period. When I retrieve the time it is about three months old even when i only just set it. The code example below best describes the problem:
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ] * Starting MySQL database server mysqld [ OK ] * Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code: GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password"; I get the output:
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems -- > mysql conflicts with mysql-server-community error: mysql conflicts with mysql-server-community
How can I really, really remove everything related to mysql / mysql-server. I read and tried all kinds of things, but on every reinstall there is still old mysql stuff there, for example an existing password. Even resetting the password does not help.
Reason of removal: it looks like the mysql setup is really corrupt, so I want to remove, and then do a fresh install. Running Ubuntu 11.04 64-bit
sander@R540:~$ sudo apt-get purge mysql-server Reading package lists... Done Building dependency tree Reading state information... Done Package mysql-server is not installed,
I installed mediawiki the other day and went with the default innodb option. However a week later something went wrong. And since I have scripts that nightly backup /var/ I just copied the backup of /var/lib/mysql/wikidb/ (as I've done with MyISAM). Then when I connect the wikidb database. I can see the tables (via "show tables"), but when I do any query with them (check table X, select * from X) I get:
Code:
Table 'wikidb.X' doesn't exist I've since read that can can't just copy the database directory like MyISAM, and there appears to be no way that I can find to restore or fix Innodb, without a dump of the data. And I never got a chance to do a mysqldump of the data. So has anybody got any idea how I can at least view the "page" table from the files I've backed up in /var/lib/mysql/wikidb/ ?
I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld] datadir=/var/lib/mysql socket = /var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package).
I can't get mysql to update from lenny (mysql-5.0) to squeeze (5.1). apt tries to start the server but comes up with some kind of configuration script error.
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
