my SQL management disapeared

[Carolina]

Hi,
I'm totaly new here, I want to set my sql management but on my homepage of directadmin it isn't written.
How come?

Sorry for my bad english but i normaly speak, read and write dutch.

Greetings
Carolina

 

[SeLLeRoNe]

Go to user level. Probably you was at admin level.

If you are not the admin, so ask your hosting provider about that.

Regards

 

[yofu]

No mYsql options

I have Admin access and I don see the link to create myql databases like you guys said in http://www.site-helper.com/mysql.html ...please help...

 

[zEitEr]

To create a MySQL database you should operate on User Level, not admin. So as admin go to a list of all user, select a proper user, login into it's account and go to MySQL management page, where you can create a new DB if it's allowed with the hosting package set for the account.

 

[yofu]

MYSQL error

ok you are tottaly right , so i did it and I get this error when I try to create a database....Error connecting to MySQL: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

 

[zEitEr]

Your mysql is either miss-configured or not running. Make sure, you've got mysqld running.

 

[yofu]

MYSQL error

txs alex in advance... well I check under system info and the MySQl says is running, where I can check if it is miss-configured and how is correctly configured?

txs for your time and consideration

cordially

yofu

 

[zEitEr]

Post here results for

stat /var/lib/mysql/mysql.sock

cat /etc/my.cnf

cat /root/.my.cnf

cat /usr/local/directadmin/conf/my.cnf

note, you might need to hide any passwords you've got there in the output before posting it here.

 

[yofu]

MYSQL error

Hi Alex, txs....

using direct admin file editor I only have this:

/etc/dovecot/dovecot.conf
/etc/exim.conf
/etc/hosts.allow
/etc/hosts.deny
/etc/httpd/conf/httpd.conf
/etc/proftpd.conf
/etc/proftpd.vhosts.conf
/etc/ssh/sshd_config
/usr/local/directadmin/conf/directadmin.conf
/usr/local/directadmin/data/admin/ip_blacklist
/usr/local/directadmin/data/admin/ip_whitelist
/usr/local/directadmin/data/templates/edit_files.txt
/usr/local/etc/php5/cgi/php.ini
/usr/local/lib/php.ini

I try under service monitor to start mysoqld -- mysqld (pid 28882 ) and click on start and I get this error :

An error has occurred

Details

/sbin/service mysqld start 2>&1


was the installation incorrect?

 

[SeLLeRoNe]

You need to run the command Alex say in SSH not from DA panel.

Regards

 

[yofu]

Hi Sellenore...

I can access using putty I have access but honestly I dont know how to call this files and edit them, can you show me where I can learn that and hwta should I do? pls?

tx for your time and consideration...

Cordially

yofu

 

[yofu]

MYSQL error

Alex I did what you say (at least I think I did it correctly) and I get this :

stat: cannot stat `/var/lib/mysql/mysql.sock': No such file or directory
cat: /etc/my.cnf: No such file or directory
cat: /root/my.cnf: No such file or directory
cat: /usr/local/directadmin/conf/my.cnf: No such file or directory

txs for your time and consideration..

cordially


yofu

 

[zEitEr]

Try to restart MySQL from within SSH console:

ps aux | grep mysql
/etc/init.d/mysqld stop
ps aux | grep mysql
/etc/init.d/mysqld start

and of course post here results of what you see there.

Your mysqld might be hanging...

 

[yofu]

MYSQL error

Hi Alex this is what I got...


# ps aux | grep mysql
root 6602 0.0 0.0 11332 1388 ? S 05:16 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/s1.atomicwarez.com.pid
mysql 6679 0.0 2.8 413928 44920 ? Sl 05:16 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/s1.atomicwarez.com.err --pid-file=/var/lib/mysql/s1.atomicwarez.com.pid
root 10679 0.0 0.0 103308 856 pts/0 S+ 08:36 0:00 grep mysql


~]# /etc/init.d/mysqld stop
ERROR! MySQL server PID file could not be found!

txs for your help, am I near to fix it?

cordially

yofu

 

[zEitEr]

kill -9 6602
ps aux | grep mysql
/etc/init.d/mysqld start

Note, you'll need to check databases, as soon as you start MySQL again:

mysqlcheck -uda_admin -p`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --auto-repair --optimize --all-databases

 

[yofu]

MYSQL error

HI Alex.. it seems that a file is missing.... i am start to understand a bot more... but I got this message:


ps aux | grep mysql
mysql 6679 0.0 2.8 413928 44920 ? Sl 05:16 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/s1.atomicwarez.com.err --pid-file=/var/lib/mysql/s1.atomicwarez.com.pid
root 11425 0.0 0.0 103308 856 pts/0 S+ 09:21 0:00 grep mysql
[root@s1 ~]# /etc/init.d/mysqld start
Starting MySQL..................................................................................................... ERROR! The server quit without updating PID file (/var/lib/mysql/s1.atomicwarez.com.pid).


I see it.. but I totally don't get it....

Txs for your time and precious help...

what do you think is next?

cordially

yofu

 

[SeLLeRoNe]

Post again result for:

ps aux | grep mysql
/etc/init.d/mysqld stop
ps aux | grep mysql

 

[zEitEr]

OK, when killing MySQL:

ps ax | grep -v grep | grep mysql | awk '{system("kill -9 "$1)}'

you should make sure, none its instance is running:

ps ax | grep -v grep | grep mysql

only then you should start MySQL:

/etc/init.d/mysqld start

And as soon as MySQL start, try this:

mysql

What you see with that?

And fix tables with mysqlcheck

p.s. Are you running Debian there?

 

[yofu]

MYSQL error

YES YES YES!!! txs Sellerone... it works !!! FINALLY!!! txs txs txs!!! WOOHHOOJ!!!!