I want to install mysql on my system. I have downloaded rpm from mysql website.
I fired rpm -ivh MySQL-server-5.5.15-1.linux2.6.i386.rpm. The result was error:
Then I tried with this command rpm -Uvh --test MySQL-server-5.5.15-1.linux2.6.i386.rpm. The result which I got was error:
How to find the dependencies or some other way to install mysql-server on my system. Or how to install it with the help of yum?
I've successfully installed mysql using yum on the latest fedora; and started it like so:
What do I do from here!
I used the command: whereis mysql
I found out it was in /usr/bin/mysql /usr/lib/mysql /usr/share/mysql ../man/man1/.gz
I attempted to execute it from root.. bin and I get the following error message:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock'
Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 Replies View RelatedIm using centos. I have install rpm for mysql
But when i have enter service mysqld start it shows mysqld: unrecognized service
And when I type mysql it shows ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
I just tried installing mysql on my vps from source code. after untaring the source code. when i tried to configure the ./configure script. iwas not able to find it. it is not there.
View 1 Replies View RelatedI'm dual booting Windows XP and the latest version of Ubuntu.
I am trying to setup VHCS (vhcs.net)
In order to do so, it requires:
* Postfix (Version 2 or greater)
* ProFTPd
* Apache (Version 2 or greater)
* Courier POP3 and IMAP
* Bind9
* MySQL (Version 4 or greater)
* iptables
how to install on Ubuntu. I have done it with Windows XP, but not Ubuntu
To install mysql follow this process. Go to your Terminal and Enter the command given below:
Code:
After installation you need to start mysql server by
Code:
After this you need to enter this command
Code:
1.First you system will ask you old mysql root password if you have installed mysql just now and not set password yet then you can enter anything or just press enter.
2. After that system will ask you twice for new password you can set a new password or you can keep it blank for no root password. I will suggest you to enter a password.
3.remove anonymous user? make it yes when you install mysql an automatic mysql user has created so remove it.
4. Disallow root login remotely. Hope you want to disallow mysql root login from remote for security of your mysql sever. If you want to use you can select no.
5. Remove test database. As anonymous user system generate and automatic database for testing.select yes to delete it.
6.Reload privileges: do yes to flush privileges.
Now you can login in your mysql server as root by this command
Code:
One more thing make sure that when you are entering this command you login your terminal as general user not as root.
Now you can create a new user by following commands.
To create databases
Code:
To see database list
Code:
Code:
Code:
Code:
Code:
Code:
If you want to work with mysql in gui mode Then you can install phpMyAdmin to install phpmy admin go to terminal and eter
Code:
And after completing installation you can login in to phpmyadmin. To login go to your browser enter [url] or Click here or you can download mysql gui client Mysql Work Bench from mysql website or Click here after installation it will be appear in programming menu. It's also cool client with mysql server activity watcher.
I'm trying to install mysql-workbench on RedHat 5 Desktop - this is what I was given, didn't pick it.I found an appropriate RPM that I downloaded from the MySQL site, but it's asking for several dependencies that I don't know how to track down.
Here's the error message I get:
Code:
]# rpm -ivh /home/confluence/Desktop/mysql-workbench-oss-5.1.18a-1fc11.x86_64.rpm
error: Failed dependencies:
libatkmm-1.6.so.1()(64bit) is needed by mysql-workbench-oss-5.1.18-1fc11.x86_64
libcairomm-1.0.so.1()(64bit) is needed by mysql-workbench-oss-5.1.18-1fc11.x86_64
[code]....
The packages that aren't installed, I'm just not sure what aI should be looking for to install them. how EXACTLY would you suggest I fix this? By exactly I mean, the dependency you are missing is part of the following package, type yum install "packagename" to fix this.
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'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 the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies View RelatedI 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)
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedI have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.
now a these days i am connect through ssh and excuting below command
#mytop mysql -u root -p <passwd>
In my mysql db i have added the userip & passwd (allowed the privileages for that ip)
If i use mysql-administrator i am getting below error
MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)
I have tried many different ways to interact with the mysql to reset the root mysql pass. This is what I got to right now
Code:
#!/bin/sh
newpass=$1
service mysqld stop
mysqld_safe --skip-grant-tables --skip-networking &
echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD("$newpass") where User="root";" >> /tmp/mysql_pass_reset.txt
[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 installed mysql on Ubuntu linux with the command apt-get install mysql-server. How do i competely uninstall it?
Is there a way when i install the server to configure the server options (e.g. where the data directory is). I know how to change this once installed but i was wondering if there was a way to do it during the installation for ease. All i remember from the installation procedure is that you can set the root password.
I tried to install the package from centosplus repo but got the error cannot find libmysqlclient.so.15.Not surprising as I have libmysqlclient.so.18. If not does anyone know how I can build postfix with support for MySQL 5.5. It doesn't help that I have never built a binary before - I found a couple of good tutorials on how to build from source that seem straight forward enough but I have no idea what needs to be specified for the postfix build.
running CentOS 5.6
MySQL5.5 (Remi)
PHP 5.3.6 (Remi)
Today I'm installing MySQL for my Django server!
I installed:MySQL-server-5.1.48-1.glibc23.i386.rpm MySQL-client- .1.48-1.glibc23.i386.rpmand can now type "MySQL" at the command prompt to play around with MySQL! W00t!
However, when trying to import MySQLdb into python, I get this error: >>> import MySQLdb ImportError: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory ... and now I'm clueless. I tried looking for libmysqlclient_r.so.15 by typing "sudo find / -name 'libmysqlclient_r.so.15'" and didn't get anything
Im trying to install mysql by this code..
But at the gunzip stage its showing "no such file" though the path is correct..im not getting that the code is correct or not?
I have a problem installing mysql ruby gem on 64bit CentOS machine.
[jacekb@vitaidealn ~]$ uname -a
Linux vitaidealn.local 2.6.18-92.el5 #1 SMP Tue Jun 10 18:51:06 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
I have been trying to install the above on my CentOS 5.5 server but am having missing libs issues. Our friend yum is not helping either. Here're some of the libs missing:
Missing Dependency: liblua-5.1.so()(64bit) is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64)
Missing Dependency: libssl.so.10()(64bit) is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64)
Missing Dependency: python(abi) = 2.6 is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64)
[Code]...
I've been trying to install MySQL in Lenny via source binaries, following the instructions given on the MySQL official website[url]
But when i try to run the scripts/mysql_install_db --user=mysql command, doesn't work.
For the record, i'm particularly interested on installing MySQL with the generic source binaries.
I'm trying to install DekiWiki, which has as a dependency mysql-server. This is what's going on:
Code:
root@servername:~# apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
[Code]...
Do you think this package might be corrupted, and if so can I manually specify a different version or a different package? I don't know what else to do; ctrl+c to kill it results in dpkg hangups that yeah, I can purge, but I'd rather not be doing that more than is really necessary.
im in the process of installing LAMP. im presently installing mysql and that's where i got into trouble...
im following the this tutorial [URL]
i tried the following :
Step 3. This is where things may start to get tricky. Begin by typing the following into Terminal:
mysql -u root
and i got this output:
root@konlah-laptop:/home/konlah# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
obviously my question is why can't i connect to local mysql?
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.
Quote:
I want to connect to MySQL Database installed on RHEL 5 using perl v 5.8.8.The available DBD perl drivers installed on my machine are:DBM, ExampleP, File, Pg, Proxy, Sponge..I downloaded DBD-mysql-2.1012 and tried installing DBD again but got the following error:Can't exec "mysql_config": No such file or directory at Makefile.PL line 167.readline() on closed filehandle PIPE at Makefile.PL line 169.On searching I found that I need to install libz-devel prior to installing driver for MySQL for Perl.
View 1 Replies View RelatedAfter updating and installing Mysql's TOP, yum broke. When trying to clean, update, or install, the following error occurs:
dingle@its:/home/dingle# yum update
There was a problem importing one of the Python modules required to run yum. The error leading to this problem was: No module named cElementTree
Please install a package which provides this module, or verify that the module is installed correctly.
It's possible that the above module doesn't match the current version of Python, which is:
2.4.3 (#1, Sep 3 2009, 15:37:12)
[GCC 4.1.2 20080704 (Red Hat 4.1.2-46)]
If you cannot solve this problem yourself, please go to the yum faq at: [URL]
I tried to resolve by reinstalling the dependency, didn't work either:
dingle@its:/home/dingle# rpm - [URL]
Retrieving [URL]
Preparing... ########################################### [100%]
package python-elementtree-1.2.6-7.el4.rf.i386 (which is newer than python-elementtree-1.2.6-5.i386) is already installed
How can I rebuild YUM appropriately so it will operate correctly?
I have a permission to use several CentOS5 computers that are connected to a server where all shared programs sit. Accordingly, all Perl users for example have an identical path to Perl (e.g. /export/user/bin). The administrator suggested I'll install all the programs I need (specifically Perl and Mysql) in my personal space, and then add them to the path before the already installed ones. Accordingly, I could add/change modules without "sudo" privileges, and without changing the global setting.
View 1 Replies View RelatedI'm trying to start the mysql server on fedora 12. service mysqld start gives me an error:
MySQL Daemon failed to start.
Starting MySQL: [FAILED]
More details
[root@localhost mysql]# which mysql
/usr/bin/mysql
[root@localhost mysql]# mysql --version
mysql Ver 14.14 Distrib 5.1.46, for redhat-linux-gnu (x86_64) using readline 5.1
And also I get a weird pop in the notification area regarding some security threat
SELINUX is preventing /usr/libexec/mysqld "read" access on plugin.frm