LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-29-2015, 11:51 PM   #1
contozo
Member
 
Registered: Jan 2013
Posts: 32

Rep: Reputation: Disabled
trouble installing mysql


Hi everyone,
i tried to install mysql on my slackware 14.1.
typed mysql_install_db --user=mysql and went to the automatic configuration of secure access and receive this "Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)".
How can remove this installation, to try to reinstall the db?


And another error when try to reinstall :
"bash-4.2# mysql_install_db --user=mysql
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
150130 9:40:11 [ERROR] mysqld: File '/var/lib/mysql/aria_log_control' not found (Errcode: 13)
150130 9:40:11 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/var/lib/mysql/aria_log_control'
150130 9:40:11 [ERROR] Plugin 'Aria' init function returned error.
150130 9:40:11 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
150130 9:40:11 [ERROR] mysqld: Can't find file: './mysql/db.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/db.frm' (errno: 13)
150130 9:40:11 [ERROR] Aborting

150130 9:40:11 [Note] /usr/libexec/mysqld: Shutdown complete


Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

shell> /scripts/mysql_install_db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

shell> /usr/libexec/mysqld --skip-grant --general-log &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /var/lib/mysql that may be helpful.

The latest information about mysql_install_db is available at
http://kb.askmonty.org/v/installing-...sql_install_db.
MariaDB is hosted on launchpad; You can find the latest source and
email lists at http://launchpad.net/maria

Please check all of the above before mailing us! And remember, if
you do mail us, you should use the /usr/bin/mysqlbug script!
bash-4.2#
"

Last edited by contozo; 01-30-2015 at 01:41 AM.
 
Old 01-30-2015, 09:22 AM   #2
yancek
LQ Guru
 
Registered: Apr 2008
Distribution: Slackware, Ubuntu, PCLinux,
Posts: 10,539

Rep: Reputation: 2496Reputation: 2496Reputation: 2496Reputation: 2496Reputation: 2496Reputation: 2496Reputation: 2496Reputation: 2496Reputation: 2496Reputation: 2496Reputation: 2496
It isn't clear what you have done. The 'root' account for mysql is not the root account for the operating system nor is the password used necessarily the same. You need to first assign a 'root' password for mysql which is explained in detail in the documentation at their site below. It would be a good idea to read through this if you are new to it so you get a basic understanding. Also

http://dev.mysql.com/doc/refman/5.1/...rivileges.html

Did you try the two commands below and if so, what was the result? What about the results of the other commands suggested?

Quote:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
 
Old 01-30-2015, 09:39 AM   #3
contozo
Member
 
Registered: Jan 2013
Posts: 32

Original Poster
Rep: Reputation: Disabled
Yes i tried , but in first one i had same error "bash-4.2# /usr/bin/mysql -u root mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)". I know that root acc for the mysql is different that the root acc for the system and supposed the bassword is "" (empty). But didnt read in documentation that first need to make root acc . Just started to do from the beginning in documentation . Thank you for reply .
I red it here http://docs.slackware.com/howtos:dat...l_on_slackware

Last edited by contozo; 01-30-2015 at 09:45 AM.
 
Old 01-30-2015, 10:00 AM   #4
contozo
Member
 
Registered: Jan 2013
Posts: 32

Original Poster
Rep: Reputation: Disabled
Solved . Just for info - when added chown -R mysql /var/lib/mysql all goes perfect
seemed mysql user didnt own the db.

Last edited by contozo; 01-30-2015 at 11:52 AM.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble Installing mySQL Administrator mTorbin Linux - Newbie 1 03-20-2006 08:33 PM
having trouble installing MySQL with RPMs on Suse 9.1 asilentmurmur Linux - Software 2 08-28-2005 09:25 AM
trouble installing mysql jacquedp Linux - Software 2 08-16-2005 12:39 PM
Trouble Installing MySQL deimosponders Mandriva 7 01-27-2005 01:18 AM
Trouble Installing mySQL. How hard could it be? Travis86 Linux - Newbie 2 09-17-2003 01:13 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:33 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration