While trying to provide schema to a database in mysql, I am getting this error: ERROR 1064 (42000) at line 15: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FUNCTION 'upd_radgroups()' RETURNS trigger AS'.I am not getting that where the problem is. ANd below is the script which i want to use to provide schema to my database in my Centos system:-
[code]...
i ,musing mysql5 at fedora12 i have just installed it but i ,m using mysqladmin -p root password mypassword it says ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqladmin -uroot password 123456' at line 1
View 10 Replies View RelatedI 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've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
My OS is ubuntu and i'm having problems with MySQL:
[code]...
tried apt-get --purge remove mysql-server and then apt-get install mysql-server but still dont work
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've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
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 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:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
I have mysql downloaded and when I type mysql into the command line I get this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
getting foll error during 'make' part of compilation of mysql v5.5.6rc
Code:
libtool: link: unsupported hardcode properties
libtool: link: See the libtool documentation for more information.
libtool: link: Fatal configuration error.
code....
I'm trying to install snort-2.8.5.3 on centos5-i386 an I get this error from ./configure --with-mysql --enable-dynamicplugin command:
ERROR: unable to find mysql headers (mysql.h)
checked in the following places
/usr
/usr/include
[Code].....
I've read here it has to do with libmysqlclient12-dev. How can I install libmysqlclient12-dev on centOS?
Is it possible to install snort from repositories using yum?
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
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).
[Code]...
I wrote a code in C to connect to MySQL by using mysql_real_connect function but I recieved error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" (by using mysql_error function).
I also did the following things: in mysql I typed 'SHOW VARIABLES LIKE '%SOCKET%'', it returned /var/lib/mysql/mysql.sock I typed 'mysql_config --socket' in shell, it returned /var/lib/mysql/mysql.sock I modified /etc/my.cnf file
I upgraded a system from 10.3 to 11.4 and I get the following error when trying to run mysql:
Will update MySQL now, if you encounter any problems, please read following file:
/usr/share/doc/packages/mysql-community-server/README.SuSE
Log files inconsistency, please merge following files manually:
/var/lib/mysql/mysqld.log
/var/log/mysqld.log
How can I correct this? Mysql will not start so I can not run any of the utilities.
I am facing some strange problem of mysql replication with ssl, my replications which working fine from more than 6 months currently stopped working after i upgrade mysql in to newver version mysql-5.1.41-2, i create new ssl self singed certs but still no sucess, when client try to connect the master using ssl its gives error SSL connection error ERROR 2026 (HY000), with out ssl its working f9.
Platform --> Fedora-11 + mysql-5.1.41-2 (both master/client)
I can seeking the problem on net, and i found the below bugzilla url related to that.
[url]
I read it but not get , either new version support x509 ssl certs or not or either new version support ssl replication or not, here below my server configuration for ssl serts
And for client
Both server and clients certs are signed with same ca but still its currently not working after the mysql upgrade first 5.1.41 and then 5.1.41-2
Either as above bugzilla url, currently mysql support ssl replication or not, or either some need to do special for working with ssl. or i wait for newver version of mysql to fix if its bug or not.
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 have been using a vps computer (for counter-strike servers) for about 4 months now, i need to install phpmyadmin + mysql + appache2. i am running debian 5.0 btw, and everything is being done through putty, and winscp (i googled on how to reinstall php and mysql and saw a program called yum. but i have'nt tried to use it) first off, i tried to update
[code]...
i did'nt know what to type, so i exited out of putty, and rentered.[/quote] later i found the command for phpadmin, installed it. entered the password for mysql. and everything. looked like it was installed ok, then i tried to go to phpadmin. i typed in internet brower (http)://82.135.231.14/phpmyadmin[/url] and it wants to send me a file. now on my last vps, i had mysql and phpadmin and it worked fine. never got this error. why is it? and how can i fix it? should i reinstall it? btw, i need it for a thing called "amxbans" and a text message system (you send a text, and you will be a admin) i think thats all i need to install.
I'm trying to install mysql on Lenny. I managed to get apache and php going just fine but i'm getting this error for mysql at the mo: The following packages have unmet dependencies.
mysql-client: Depends: mysql-client-5.1 but it is not going to be installed
mysql-server: Depends: mysql-server-5.1 but it is not going to be installed
E: Broken packages
I don'thave a cluse how to fix this. I've read that adding a line in sources.
I installed MySQL 5 on Fedora Core 13 guest on Win Vista host. After I ran the bash script to install it:
Code:
groupadd mysql
useradd -g mysql
tar -xvf mysql-5.1.48.tar.gz
cd mysql-5.1.48
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions -fno-rtti"
./configure --prefix=/usr/local/mysql --with-mysql-ldflags=all-static --with-charset=utf8
make test
make
I ran the mysql but I received the error 2002 so I changed the my.cnf with medium.cnf, pointed in the file the path to the mysql.sock file and tried changing the owner of mysql.sock to the user mysql. It didn't work so in the end I gave 777 permissions (755 didn't work either). Now the error reporting when starting mysql is
Code:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111).
I have encountered an error while installing 5.5.13. I have downloaded mysql mysql-5.5.13-linux2.6-i686.tar.gz from my windows machine and moved it to Linux (since no net access in Linux machine) and extracted. i have followed the steps present in INSTALL-BINARY file. When I entered scripts/mysql_install_db --user=mysql this command it shows an error sayin Installing MySQL system tables. /bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory. Whether I need to install libaio.so.1 file? If so what the file is? And for what purpose we need to install that file? And why didnt they mention it in their steps for installation?
View 2 Replies View RelatedWhen my Fedora server boots it fails starting the MySQL server also if i try to start it from a prompt it says "fail" but the funny thing is that it works. Now i could just say "what the hell it works" but i hate seeing the red error on boot. Fedora boot, fail starting MySQL MySQL server works after boot anyway manual start it fails, but also here it works anyway
View 2 Replies View RelatedI am getting this error when I try to connect to my MySQL database from a PHP page. MySQL is working fine on it's own and PHP is working on it's own. "Fatal error: Call to undefined function mysql_connect() in /usr/local/htdocs/test.php on line 11" I have found instances on the Internet where other people had the same problem but from everything I've read, none of it appears to do anything for me. I have read that I need the "extension=mysql.so" in my php.ini file and to uncomment it but it's not in there and I don't even have the "mysql.so" file. Many people have said to install the MySQL "devel" package, which I have also done and it is still not adding the file. (Tried "rpm -i php-mysql") I have also tried running the PHP ./configure again with the "--with-mysql". After all of these I still can't seem to get any further than I was when I found out I had a problem
View 10 Replies View RelatedRunning
openSUSE 11.3 (x86_64)
Linux 2.6.34.7-0.7-desktop x86_64
mysql-community-server_64 5.1.46-2.18-x86_64 from vendor openSUSE
php5-mysql 5.3.3-0.7.1-x86_64 from vendor openSUSE
Apache2 2.2.15-3.7-x86_64
apache2-mod_php5 5.3.3-0.7.1-x86_64 from vendor openSUSE
Trying to start mysql in YaST > system services (runlevel) >
Expert mode
gives following message
/etc/init.d/mysql start returned 1 (unspecified error):
I have been trying to set up GLPI with OCS inventory but am having issues installing OCS. I have been following the below directions and when i go to [url] the login page gives me an error.
Quote:
Now i have not tried to log in yet so its like there is a auto log in. What config file do i have to edit to turn this off?
Something that may be effecting this would be the following step (below high lighted in red)i do not do as i do not see this line when installing. I am installing 1.3.1 not 1.0 like the guide was written for, which i think is what is causing me not to see this step.
This install procedure was meant for Debian Etch but should work for Ubuntu. Just add sudo to the beginning of all the commands. Or you can login as root and run them by typing:
At a command prompt type:
i installed mysql 5.1, the workbench and glassfish along with netbeans for an application I plan to build using the java EE. Glassfish is on local host 8080 and when I installed mysql after that, trying to start mysql from command prompt or even connecting through the workbench gives me error. for example going through the terminal and just typing mysql gives me: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) what should I do so both servers can run at the same time when deploying my application? on windows this is all handled for me. but apparently thats not the case on ubuntu
View 2 Replies View RelatedI'm trying to install the squeezebox server software in Ubuntu 9.10 and I'm getting an error when it tries to install mysql-server. Seems like people have run into this before [URL]... but so far, I can't find a solution.
[code]...
Mental note: ignore start-up process scroll.
Okay, now MySQL is just being (even more) difficult. Prior to boot's starting MySQL, I notice the line
Code:
/etc/rc2.d/S19mysql: line 132: syntax error near unexpected token ')'
Near?? Line 132 consists of
Code:
'stop')
Which is proper, and identical to all the other /etc/rc#.d/S19mysql scripts that don't result in errors. C'mon...!
Installing MySQL system tables...
ERROR: 1136 Column count doesn't match value count at row 1
100527 18:26:49 [ERROR] Aborting
100527 18:26:49 [Note] /usr/local/libexec/mysqld: Shutdown complete
Installation of system tables failed!