Quote:
Originally posted by ScooterB
There are a couple of things to check.
1) Check in your /root .bash_profile file and insure that your PATH line reads as PATH=$PATH:$HOME/bin:/usr/local/mysql/bin !!!! I that file does not exist in my /root folder !!!
2) Make sure that whatever user you're trying to log into MySQL with has file permissions to access the database
3) Check /etc/my.cnf and insure that the correct paths are listed for file access
!!!! I that file does not exist in my /etcfolder !!!
4) Make sure that the MySQL daemon is in fact actually running. ps -ef | grep mysql. Should return about three or four lines with different processes running.
5) Try logging in : /usr/local/mysql/bin/mysqld_safe --user=mysql & (This of course depends on if you have a user called mysql)
I had the same problem with my mysql and it mostly was file access permissions. I am installing an IDS system with Snort and I had to make sure that my user "snort" had permission to access the files. I simply made him/her a member of the mysql group and allowed that group to have access. Seemed to work. I still don't have it all the way up but am progressing. Try these things and repost if you don't have success.
|
I am starting to get the feeling that i didnt actually install mysql properly
but take a look at this
MyAgony:/home/me# dpkg -l | grep mysql
ii libdbd-mysql-p 1.2216-2 mySQL database interface for Perl
ii libmysqlclient 3.23.49-8.5 mysql database client library
ii mysql-client 3.23.49-8.5 mysql database client binaries
ii mysql-common 3.23.49-8.5 mysql database common files (e.g. /etc/mysql
ii mysql-server 3.23.49-8.5 mysql database server binaries
ii php4-mysql 4.1.2-6woody3 MySQL module for php4
MyAgony:/home/me#
This is why i love linux some much!!