VectorLinux
April 24, 2014, 03:33:59 am *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Visit our home page for VL info. To search the old message board go to http://vectorlinux.com/forum1. The first VL forum is temporarily offline until we can find a host for it. Thanks for your patience.
 
Now powered by KnowledgeDex.
   Home   Help Search Login Register  
Please support VectorLinux!
Pages: 1 [2]
  Print  
Author Topic: mysql[solved]  (Read 4801 times)
cse_200509
Member
*
Posts: 14


« Reply #15 on: January 21, 2008, 09:46:20 am »

I'd tell you to build it yourself from ports, but you are running 5.8.... not sure how ports work there



thanx
should not we atleast try?
Logged
M0E-lnx
Administrator
Vectorian
*****
Posts: 3134



« Reply #16 on: January 21, 2008, 09:48:47 am »

You can...
First make sure you have the "extra" section of the repos enabled
Try this as root in a terminal
slapt-get --update && slapt-get --searcn cruxports4slack
if it finds the package then do
slapt-get --install cruxports4slack
let me know how that goes, we'll come up with the rest of the plan...

Just dont give up ... I need you to install mysql because I'm trying to lean mysql myself... maybe we can help each other out Wink
« Last Edit: January 21, 2008, 09:50:28 am by M0E-lnx » Logged

cse_200509
Member
*
Posts: 14


« Reply #17 on: January 21, 2008, 10:03:11 am »

You can...
First make sure you have the "extra" section of the repos enabled
Try this as root in a terminal
slapt-get --update && slapt-get --searcn cruxports4slack
if it finds the package then do
slapt-get --install cruxports4slack
let me know how that goes, we'll come up with the rest of the plan...

Just dont give up ... I need you to install mysql because I'm trying to lean mysql myself... maybe we can help each other out Wink



great!
every thing done!
so let's proceed.
Logged
M0E-lnx
Administrator
Vectorian
*****
Posts: 3134



« Reply #18 on: January 21, 2008, 10:10:46 am »

as root in a terminal you need to do this
Code:
ports -u
That will take a while to complete. ... but when it finally does, execute this
Code:
ports -l | grep mysql
You will see this
Quote
opt/mysql
opt/mysql-python
opt/mysql-ruby
So you do this
Code:
cd /usr/ports/opt/mysql
Then to begin the build and install ... execute this command
Code:
pkgmk -d -i
if everything completes with no errors, you should have just built and installed a good mysql pacakge...
let me know how it goes

_EDIT_
You may need to run "export VL_PACKAGER=<your_nick_here>" before running pkgmk
_END_OF_EDIT_
« Last Edit: January 21, 2008, 10:12:54 am by M0E-lnx » Logged

cse_200509
Member
*
Posts: 14


« Reply #19 on: January 21, 2008, 11:34:24 am »

as root in a terminal you need to do this
Code:
ports -u
That will take a while to complete. ... but when it finally does, execute this
Code:
ports -l | grep mysql
You will see this
Quote
opt/mysql
opt/mysql-python
opt/mysql-ruby
So you do this
Code:
cd /usr/ports/opt/mysql
Then to begin the build and install ... execute this command
Code:
pkgmk -d -i
if everything completes with no errors, you should have just built and installed a good mysql pacakge...
let me know how it goes

_EDIT_
You may need to run "export VL_PACKAGER=<your_nick_here>" before running pkgmk
_END_OF_EDIT_



what u mean by:
                  <your_nick_here>
Logged
kidd
Packager
Vectorian
****
Posts: 682


« Reply #20 on: January 21, 2008, 11:37:03 am »

before typing the pkgmk command, in the same terminal type:
Code:
export VL_PACKAGER=cse

Then, the package will show 'Packaged by: cse' in the description
Logged

cse_200509
Member
*
Posts: 14


« Reply #21 on: January 23, 2008, 05:27:24 am »

as root in a terminal you need to do this
Code:
ports -u
That will take a while to complete. ... but when it finally does, execute this
Code:
ports -l | grep mysql
You will see this
Quote
opt/mysql
opt/mysql-python
opt/mysql-ruby
So you do this
Code:
cd /usr/ports/opt/mysql
Then to begin the build and install ... execute this command
Code:
pkgmk -d -i
if everything completes with no errors, you should have just built and installed a good mysql pacakge...
let me know how it goes

_EDIT_
You may need to run "export VL_PACKAGER=<your_nick_here>" before running pkgmk
_END_OF_EDIT_



ok
operation suceeded.
so what to do next?

i tried to start but got error message:

root:# /etc/rc.d/mysqld start
vector://
root:# 080123 18:51:53 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
080123 18:51:53 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
080123 18:51:53 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
080123 18:51:53 [ERROR] /usr/sbin/mysqld: Error on delete of '/var/run/mysqld.pid' (Errcode: 13)
                                               
Logged
M0E-lnx
Administrator
Vectorian
*****
Posts: 3134



« Reply #22 on: January 23, 2008, 06:21:39 am »

I think you need to run the installer to do the initial setup...
you run it like this... as root in a germinal
Code:
mysql_install_db

Let me know if you need more help.
HTH.

Logged

cse_200509
Member
*
Posts: 14


« Reply #23 on: January 23, 2008, 06:39:54 am »

I think you need to run the installer to do the initial setup...
you run it like this... as root in a germinal
Code:
mysql_install_db

Let me know if you need more help.
HTH.




got it right!


root:# 080123 20:03:35 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51-log'  socket: '/tmp/mysql.sock'  port: 0  Source distribution

is it done?
« Last Edit: January 23, 2008, 06:49:07 am by cse_200509 » Logged
M0E-lnx
Administrator
Vectorian
*****
Posts: 3134



« Reply #24 on: January 23, 2008, 06:48:13 am »

Alright!
There you go... maybe you can help me learn the mysql thing now...
Logged

cse_200509
Member
*
Posts: 14


« Reply #25 on: January 23, 2008, 07:23:59 am »

Alright!
There you go... maybe you can help me learn the mysql thing now...
ok
but.....
after " /etc/rc.d/mysqld start "
the shell should have like this:

mysql>

m i correct?
Logged
M0E-lnx
Administrator
Vectorian
*****
Posts: 3134



« Reply #26 on: January 23, 2008, 07:36:41 am »

not exactly.
After you start the service, you need to log into the mysql server. After you do that, then your shell will look like that

You should do this
Code:
mysql -h localhost -uroot
that will log you into the mysql server
Logged

cse_200509
Member
*
Posts: 14


« Reply #27 on: January 23, 2008, 07:45:32 am »

not exactly.
After you start the service, you need to log into the mysql server. After you do that, then your shell will look like that

You should do this
Code:
mysql -h localhost -uroot
that will log you into the mysql server


thanx
done !
Logged
JohnB316
Administrator
Vectorian
*****
Posts: 1346


Registered Linux User #386728


« Reply #28 on: January 23, 2008, 06:41:30 pm »

Is this issue solved? If it is, would the person who started this thread please modify the original post in this thread and add SOLVED to the beginning of the title. Thanks very much.

Cheers,
John
Logged

VL 6.0 SOHO latest alpha on one box, VL 5.9 Lite on the other.
Pages: 1 [2]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!