Re: Insatlling MySQL



tg@xxxxxxxxx wrote:
Now having bought a dedicated server at a company, most things are
working but not MySQL. OS is Centos and I am working at the console. I
can find mopst of the mysql start-files at /urs/bin.
When I try to start with ./mysql I get this message:

You should use the init script to start mysql, this works fine if you was smart enough to install the mysql that came with CentOS (the one you can download from mysql.com is a general version, which don't work as well in all environments).

You look in /etc/init.d (if not there, /etc/rc.d/init.d/)

example: /etc/init.d/mysql start

If you want the mysql to be started automatically you use the chkconfig to set on which runlevels mysql will be started, keep in mind that see to that it's turned off on levels 0 and 6 as those are the halt and reboot levels.


Can't connect to local MySQL server through
socket'/var/lib/mysql/mysql.sock' (2)

At /var/lib/ there are no mysql directory at all. Looking for file
mysql.sock with locate mysql.sock I get no result.

mysql is the command line client, it needs the mysqld to be started before it can connect, on a localhost, the socket method to access the server is the most common, while for remote servers you use tcp-stack.



//Aho
.



Relevant Pages

  • Re: Enabling MySQL for PHP on CentOS 5
    ... that CentOS 5 came with an installation of MySQL but it only seemed ... I installed both of those and the mysql server is ... I cannot get PHP to use mysql correctly. ... enabled but I guess centos didnt do that. ...
    (comp.os.linux.misc)
  • Re: Enabling MySQL for PHP on CentOS 5
    ... settings that come right out of the box. ... I installed both of those and the mysql server is ... I cannot get PHP to use mysql correctly. ... the CentOS php.ini. ...
    (comp.os.linux.misc)
  • new php and mysql stop playing together
    ... A bit of a newbie as far as mysql and php adminning I am; ... another server trying the latest mysql 5.0.*). ... OS: CentOS release 4.4 ...
    (comp.lang.php)
  • MySQL
    ... I tried to use MySQL and I did probably something wrong, ... I decided to unimstall everything (on CentOS) (Via the GUI and selecting the ...
    (linux.redhat.install)
  • Re: Apache or PHP.INI setup problem
    ... All is well when I upload to remote servers, but I get a blank page ... PHP Version 4.4.1 and ... MySQL 3.23.49 on Windows XP Pro ...
    (alt.php)