I'm trying to start my MySQL server, and it fails if the /etc/mysql/my.cnf file is there. If it isn't, then it fails - syslog shows me this:
Code:
Jun 5 11:02:53 myhost /etc/init.d/mysql[21733]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jun 5 11:02:53 myhost /etc/init.d/mysql[21733]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
[Code].....
I've just upgraded to 9.10, and mysql fails to start. When I do an /etc/init.d/mysql start, I just get
* Starting MySQL database server mysqld ...fail!with no additional errors or information to say what went wrong. I saw this thread http://ubuntuforums.org/showthread.php?t=1322070 but the fix mentioned does not apply, as I don't have the #skip bsd line in my config file.
I want to setup my MySQL database and have MySQL up and running. I sill look for a good editor to add and configure my tables, it appears that MySQL Administrator is the only GUI client available.
But when I try to add a foreign key to one of my tables, there appears to be a problem. Both of my tables are InnoDB and both have a primary key.
-First I choose the tab "Foreign Keys" on my CLIENT table.
-Then I press the green + sign to add a foreign key, it is default named new_fk_constraint.
-I choose my table USER in the Refer.Table dropdownbox
-And then I should be able to match the FK field and the PK field in the box on the right... but this box is empty. Double clicking shows nothing. I only can drag the user_id of the USER table to it, but have no option to select the foreign column.
What the hell is wrong here??? This client is years old and should be really REALLY working IMHO! I was told by a friend that there is no good client available and therefore he is using some Windows program for this...
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 was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
I've installed MySQL-server-community-5.1.35-0.rhel5.x86_64.rpm, client and devel on my 64 bit server having CentOS 5.4 (Final) as operating system. Now when I setup my.cnf file and add an entry "init-file=/usr/src/script.sql" and restart Mysql service then Mysql fails to start but when I comment init-file portion in my.cnf file then mysql runs fine. Please find below log file entry in mysql log
100304 3:03:38 [ERROR] /usr/sbin/mysqld: File '/usr/src/scripts/startup.sql' not found (Errcode: 13)
100304 3:03:38 [ERROR] Aborting
I have verified that file exist on the location mentioned in my.cnf file. Can anybody please suggest fix of this problem.
Previously mysql was fine under FC14. Upgraded to FC15 64bit
System:
IntelPentium(R) Dual CPU T3400 @ 2.16GHz 2
uname -r -v
2.6.38.8-35.fc15.x86_64 #1 SMP Wed Jul 6 13:58:54 UTC 2011
Mysql would not start when I tried to use it. Failed with
Quote:
service mysqld start
Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details.
Problem was these two lines in my /etc/my.cnf
Quote:
#default-character-set=utf8
#default-collation=utf8_general_ci
As you can see these are now commented out.
Result
Quote:
[root@centos etc]# service mysqld start
Starting mysqld (via systemctl): [ OK ]
or how to relate that I want them to be utf8 in the conf file,
Im having a major problem with mysql-server failing to install.The installation stoppes on "Running Transactions" (have tried waiting for 10 minutes). When I use Ctrl+C an error appears:error: %pre(mysql-server-5.0.77-4.el5_5.4.x86_64) scriptlet failed, signal 2 error: install: %pre scriptlet failed (2), skipping mysql-server-5.0.77-4.el5_5.4
View 2 Replies View RelatedI am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
I got assigned to a project, where the installation is done over ansible. As I'm new in linux, python, django, ansible I wanted to try this out on a empty linux debian.
Code: Select alluname -a
Linux DebianABC 3.16.0-4 amd64 #1 SMP Debian 3.16.7-ckt20-1+deb8u4 (2016-02-29) x86 64 Gnu/Linux
When I now run my ansible playbook it tries to install mysql and suddenly I get an error:
Code: Select all:stderr: DEPRECATION: --allow-external has been deprecated and will be removed in the future. Due to changes in the repository protocol, it no longer has any effect.
DEPRECATION: --allow-unverified has been deprecated and will be removed in the future. Due to changes in the repository protocol, it no longer has any effect.
Could not find a version that satisfies the requirement mysql-connector-python==1.0.12 (from -r /home/abc/abcTest/requirements.pip (line 36)) (from versions: )
No matching distribution found for mysql-connector-python==1.0.12 (from -r /home/abc/abcTest/requirements.pip (line 36))
FATAL: all hosts have already failed -- aborting
So I checked the target machine and tried to run
pip install -vvv -r requirement.txt mysql-connector-python
As version 1.0.12 is an old version, I was searching and tried the following: [URL] ....
But also if I run the installation by direct download I have the same error message:
Code: Select allabc@DebianABC:/home/abc/abcTest$ pip install -r requirements.pip -vvv mysql-connector-python
Collecting http://cdn.mysql.com//Downloads/Connector-Python/mysql-connector-python-1.0.12.tar.gz (from -r requirements.pip (line 36))
Starting new HTTP connection (1): cdn.mysql.com
"GET //Downloads/Connector-Python/mysql-connector-python-1.0.12.tar.gz HTTP/1.1" 200 230923
[Code] ....
I was reading about the version requirements from PEP: [URL] .... but as the version looks ok, this should not be the problem.
My MySQL replication slave failed,while reading a large size table from master.Thhe information from error.logError 'Unknown table engine 'InnoDB'' on query. Default database: 'test'. Query: I am sure that table is a Big size table..
View 11 Replies View RelatedI've recently installed a RedHat Enterprise Linux server and am attempting to get PHP/MySQL installed on it. It cannot load the dynamic php mysql module, giving me an error (in /var/log/error_log) that reads as follows:
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysql.so' - /usr/lib/php/modules/mysql.so: undefined symbol: executor_globals in Unknown on line 0
(In fact, it fails to load ALL of the dynamic php modules, either with the "undefined symbol: executor_global" or "undefined symbol: core_globals" I DO NOT WANT to compile anything -- I want to stay with stock RedHat released software.
[root@hostname-suppressed httpd]# uname -a
Linux hostname-suppressed 2.6.18-194.17.4.el5PAE #1 SMP Wed Oct 20 13:13:33 EDT 2010 i686 athlon i386 GNU/Linux
[root@hostname-suppressed httpd]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.5 (Tikanga)
[code]....
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
[Code]...
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 don't know. I have had tons of issues with the Linux today. Now when I try and start mysql it just fails. the syslog says code...
The command mysql results in:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I have even tried to uninstall mysql and reinstall it an nothing works. Any suggestions?
I have probably found a bug in the Ubuntu php5 package. At first I thought it's a problem with Zend Framework, which I use, then I thought it's a php issue, but now it seems to be a problem with Ubuntu's php packages. My problem is that under certain conditions, php is going to read records from the mysql database table infinite times. For a much more detailed description of the bug,[URL]..
I've tried on an x86 Ubuntu Desktop edition, and an x64 Ubuntu Server edition, both 10.04, and both had this bug. I have set up a test system (x86 Ubuntu Server edition 10.04), and compiled apache2 and php5 from source, but used the mysql-server package from the repository. And I couldn't reproduce the bug. However, after copying the self-compiled libphp5.so file from the test system to the desktop that produces the error, I could still reproduce the error on the desktop. This suggests me that the problem is either not in php, or - more probably - there are multiple php binaries used in the repository version, and therefore it doesn't matter that I've copied my libphp5.so because mysql functions are somewhere else. I've found a mysql.so file in /usr/lib/php5/20090626+lfs coming from the php5-mysql package. Does that have anything to do with this issue?
ive been trying to fix this for a while. i dont have the original my.cnf, but i dont even know if thats the error:
Code:
pavel@pvl1:~$ sudo service mysql start
^C
pavel@pvl1:~$ cd /var/log/[code]....
Is there a php,mysql built in?What folder do i put my website?What command do i need to use to start and stop apache?If there isnt php,mysql built in how do i install it ?
View 9 Replies View RelatedI have trouble with MySQL server on my Ubuntu 11.04.Below is what I get in Terminal
root@linux:/home/karl# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the
service(
[code]....
I'm using ubuntu 10.04 LTS I install mysql..Code: sudo apt-get install mysql-server.I set up my password and confirm,I type mysql at the terminal and i get this back.
View 1 Replies View RelatedMy mysql server won't start on my machine. It simply fails with no errors.
Code:
sudo /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [fail]
When I run cat /var/log/mysql.err the file is empty, thinking this might be a permissions issue
I tried chowning to a mysql user. Here's the current permissions.
Code:
ls -alh /var/log/mysql*
-rw-r----- 1 mysql adm 0 2009-09-30 11:08 /var/log/mysql.err
-rw-r----- 1 mysql adm 0 2010-01-15 09:07 /var/log/mysql.log
-rw-r----- 1 mysql adm 20 2009-11-25 07:35 /var/log/mysql.log.1.gz
-rw-r----- 1 mysql adm 20 2009-11-24 07:59 /var/log/mysql.log.2.gz
-rw-r----- 1 mysql adm 20 2009-11-23 07:56 /var/log/mysql.log.3.gz
-rw-r----- 1 mysql adm 20 2009-11-22 07:54 /var/log/mysql.log.4.gz
-rw-r----- 1 mysql adm 20 2009-11-21 07:47 /var/log/mysql.log.5.gz
-rw-r----- 1 mysql adm 20 2009-11-20 07:43 /var/log/mysql.log.6.gz
-rw-r----- 1 mysql adm 20 2009-11-19 07:35 /var/log/mysql.log.7.gz
/var/log/mysql:
total 8.0K
drwxrwsrwx 2 mysql adm 4.0K 2009-09-30 11:08 .
drwxr-xr-x 16 root root 4.0K 2010-01-15 10:24 ..
Still having the same issue, mysql server is still failing and /var/log/mysql.err is still empty.
I set up mod_proxy in order to get rid of :8080 now I cant access phpmyadmin through the browser. what is the quickest way to turn off mod_proxy and access phpmyadmin? I would like to optimize the tables and back up the sql file. I just need to turn it on for a bit, and then enable mod_proxy again.Right now, if I got to localhost/phpmyadmin, it redirects to the main application.
I have used a2enmod, and added
sudo a2enmod proxy
sudo a2enmod proxy_http
sudo a2enmod proxy_ajp
[Code]...
I'm using ubuntu 9.10 64bit and I'want to configure php mysql and lampp. Also the package mysql-ser is already installed, so if I install MYSQL GUI tools(Administrator, query browser..) from my synaptic package manager will it detect the mysql already installed ? Also tried configuring lampp by extracting it in my /opt directory and i started the server, which MySQL ll it detect the one which was previously installed otr the oin that in gui tools ?
Also think the current ubuntu repository does't have latest build of mysql GUI tools, so how the above mentioned things ll change if I try to download the individual package.
Oveall what I want is to configure Mysql GUI tools, Mysql workbench, xampp and php(For this I'm using Bluefish and Komposer). Please help me out so that I can leave windows for my Web-projects.
how i can instal mysql,apache and php through my usb. what commands do i need?
View 2 Replies View RelatedMy config:
Ubuntu 9.0.4 (all up to date with security patches)
Apache 2.2.11
MySQL version 5.0.75
PHP Version 5.2.6-3ubuntu4.5
I'm running Ubuntu as a Virtual machine with VMWare on top of a Windows 2008 Server. It has been working perfectly for nearly 9 months. I have one processor and 2GB of Ram assigned to the Virtual machine. Memory usage seldom ever reaches more than 50%, swapfile is hardly used either. I noticed recently that sites were loading very slow from time to time. Webmin showed me that USER / KERNEL were together using 100% cpu. I then started searching for answers to what was causing this and then read about using HTOP. I then installed HTOP and found that the following processes were the culprits
/usr/sbin/mysqld
/usr/sbin/apache2 -k start
There are multiple instances of mysqld and apache2 listed in HTOP, I assume this is because I run multiple sites on the box. It does however seem limited to only one or two PID's that are repeatedly maxing out the CPU at 100% (every 30 seconds to a minute) sometimes the CPU will stay maxed at 100% for nearly a minute and then free itself again but it is doing this continually. At the point when the CPU maxes out at 100% there will be one instance of mySQLD and one instance of Apache2 right at the top of HTOP and between the two they will be hogging 100% cpu. All the sites are either Wordpress or Joomla sites and I am quite confident it's one of these sites causing a problem.
My issue is that I cannot pin down which PID belongs to which site. Then, once I know which site it is how do I then trace what process / file inside that site is casuing the problem? I figured one of my busiest sites (wordpress) might be the culprit and I installed the W3 Total Cache plugin today but that has not helped this 100% cpu problem, so for all I know it might be another WP site on the box or even one of the Joomla sites. I've noticed that the TIME column on the one MYSQLD instance that maxes out is very long so it seems like Mysql is keeping some connection open or something?
I just installed a brand new ubuntu server 10.04 32-bit, choosing the LAMP option on install. Upon reboot I couldn't connect to mysql from another machine, so on this new server I changed the file at /var/mysql/my.cnf
[Code]...
Ubuntu server 10.04 comes with a new event based startup system, and I wonder if that can be responsible for this problem. The server has been upgraded from 9.10. On reboot mysql does not always manage to start... /var/log/mysql/error.log has info similar to this:
100511 19:05:00 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
100511 19:05:00 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100511 19:05:00 [ERROR] Aborting
So apparently port 3306 is not 100% unused when mysql tries to open it or somehow network connections are not ready, even if mysql start is supposed to wait for 'net-device-up' and 'local-filesystems' according to /etc/init/mysql.conf. This does not happen on all reboots. I am supposed to be able to start it manually with command 'start mysql' but that does not seem to work also. When I try start it again, it says mysql is running but no databases can be reached and mysqld is not active, reboot and good luck is all that helps...
As far as I know there are no firewalls installed, at least none I have manually configured and it has worked with no problems on 9.10. So this new upstart thing seems responsible. It simply does not let mysql wait until it can start in good way. That also explains why it's a random problem. If all starts happen when and if there is free processor time, it does not always start things in the same order on every reboot. The key here is port 3306, or whatever port mysql is configured to use. The upstart system simply needs delay the start until the port is 100% free and available for the system to use.
It took a while but I got my home webserver setup and running with mysql. Now I want to import a 70MB MSSQL backup file from my hosting company. I noticed phpMyAdmin can import up to 2MB. Any suggestions on how to do this for a larger file. I do have access to the server running SSH so I'm not opposed to using the command line if I need to.
View 2 Replies View RelatedWith the new realease of Ubuntu 10.04 LTS, I was wondering if there was going to be a package for installing Mysql Cluster Server 7.1
If not does anyone know of a good walkthrough for compiling and installing it in Ubuntu 10.04 LTS?
does ubuntu 10.04 support multithread on mysql 32 bit?
View 8 Replies View Related