LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 05-14-2005, 12:41 AM   #1
kornerr
Member
 
Registered: Dec 2004
Location: Russia, Siberia, Kemerovo
Distribution: Slackware
Posts: 893

Rep: Reputation: 35
Tell my how to set up "mysql" step by step, please


I've installed it. But it doesn't want to run.
AFAIK this is because I have no grant tables.
How to create them? What to do after that?
And I have no some "socket" (I don't know how to make it).
Can you tell my step by step how to set it up so that I can run avarage commands (select, create, etc).
Thanks.
 
Old 05-14-2005, 06:04 AM   #2
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
Here you go.. Chapter 2 of the online MyQL Reference Manual:

http://dev.mysql.com/doc/mysql/en/installing.html

You should really ask more detailed questions so members here don't have to rewrite information that is already out there, or you'll just get relinked to it.. etc.
 
Old 05-14-2005, 06:32 AM   #3
juanbobo
Member
 
Registered: Mar 2005
Location: Chicago
Distribution: Gentoo AMD64
Posts: 365

Rep: Reputation: 30
chown mysql:mysql all of the files in the mysql directory under /var and in its subdirectory. Make sure you set a password with mysqladmin too.

John
 
Old 05-14-2005, 11:11 AM   #4
kornerr
Member
 
Registered: Dec 2004
Location: Russia, Siberia, Kemerovo
Distribution: Slackware
Posts: 893

Original Poster
Rep: Reputation: 35
You're right - I've become very lazy...
 
Old 05-15-2005, 09:17 AM   #5
kornerr
Member
 
Registered: Dec 2004
Location: Russia, Siberia, Kemerovo
Distribution: Slackware
Posts: 893

Original Poster
Rep: Reputation: 35
Well, I still don't uderstand what to do.
When I run "mysql_install_db" it prints:
Code:
root@darkstar:~# mysql_install_db
Installing all prepared tables
050515 22:11:25  /usr/libexec/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h darkstar password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

[1]+  Done                    mysqld_safe
root@darkstar:~#
Then I do what it tells me to:
Code:
root@darkstar:~# mysqladmin -u root xxx xxx
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!
root@darkstar:~#
But I have no socket! And I didn't find how to create it.
"mysqld" doesn't run too:
Code:
root@darkstar:~# mysqld_safe &
[1] 884
root@darkstar:~# Starting mysqld daemon with databases from /var/lib/mysql
050515 22:13:35  mysqld ended


[1]+  Done                    mysqld_safe
root@darkstar:~#
Can anyone help me.
Thanks.

Last edited by kornerr; 05-16-2005 at 09:10 AM.
 
Old 05-16-2005, 09:14 AM   #6
kornerr
Member
 
Registered: Dec 2004
Location: Russia, Siberia, Kemerovo
Distribution: Slackware
Posts: 893

Original Poster
Rep: Reputation: 35
Can anyone help me?
 
Old 05-16-2005, 11:23 AM   #7
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
chown -R mysql.mysql /var/lib/mysql

Then attempt to start mysql.
 
Old 05-16-2005, 12:00 PM   #8
kornerr
Member
 
Registered: Dec 2004
Location: Russia, Siberia, Kemerovo
Distribution: Slackware
Posts: 893

Original Poster
Rep: Reputation: 35
Thanks, trickykid! This works!
"mysqld_safe" works.
But I'm sure to have other questions tomorrow... so don't forget this thread
 
  


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 On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LFS 6.1 step 5.7: "ld: no input file" when compiling dummy.c zonk Linux From Scratch 6 09-05-2005 01:51 AM
RH Linux 9.0 installation step "Auto partitioning" not able to read partition table awahab Linux - Newbie 5 05-19-2005 07:53 AM
linux-wlan-ng installation wont go past the "make all" step apu95 Mandriva 5 10-31-2004 09:37 PM
new user - MDK 10 installer freezing (btwn lic. agreement and "security" step) undertow Mandriva 2 03-24-2004 07:42 PM
Step-by-step to set up a RedHat Linux box for use as a Windows Server? Hercules Linux - Software 2 11-16-2003 11:16 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 09:08 PM.

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