VectorLinux

Please login or register.

Login with username, password and session length
Advanced search  

News:

Visit our home page for VL info. For support and documentation, visit the Vector Linux Knowledge Center or search the Knowledge Center and this Forum using the search box above.

Pages: 1 [2]

Author Topic: mysql[solved]  (Read 6447 times)

cse_200509

  • Member
  • *
  • Posts: 14
Re: mysql
« 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: 3256
Re: mysql
« 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 ;)
« Last Edit: January 21, 2008, 09:50:28 am by M0E-lnx »
Logged

cse_200509

  • Member
  • *
  • Posts: 14
Re: mysql
« 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 ;)



great!
every thing done!
so let's proceed.
Logged

M0E-lnx

  • Administrator
  • Vectorian
  • *****
  • Posts: 3256
Re: mysql
« Reply #18 on: January 21, 2008, 10:10:46 am »

as root in a terminal you need to do this
Code: [Select]
ports -u
That will take a while to complete. ... but when it finally does, execute this
Code: [Select]
ports -l | grep mysql
You will see this
Quote
opt/mysql
opt/mysql-python
opt/mysql-ruby
So you do this
Code: [Select]
cd /usr/ports/opt/mysql
Then to begin the build and install ... execute this command
Code: [Select]
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
Re: mysql
« Reply #19 on: January 21, 2008, 11:34:24 am »

as root in a terminal you need to do this
Code: [Select]
ports -u
That will take a while to complete. ... but when it finally does, execute this
Code: [Select]
ports -l | grep mysql
You will see this
Quote
opt/mysql
opt/mysql-python
opt/mysql-ruby
So you do this
Code: [Select]
cd /usr/ports/opt/mysql
Then to begin the build and install ... execute this command
Code: [Select]
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
Re: mysql
« Reply #20 on: January 21, 2008, 11:37:03 am »

before typing the pkgmk command, in the same terminal type:
Code: [Select]
export VL_PACKAGER=cse
Then, the package will show 'Packaged by: cse' in the description

cse_200509

  • Member
  • *
  • Posts: 14
Re: mysql
« Reply #21 on: January 23, 2008, 05:27:24 am »

as root in a terminal you need to do this
Code: [Select]
ports -u
That will take a while to complete. ... but when it finally does, execute this
Code: [Select]
ports -l | grep mysql
You will see this
Quote
opt/mysql
opt/mysql-python
opt/mysql-ruby
So you do this
Code: [Select]
cd /usr/ports/opt/mysql
Then to begin the build and install ... execute this command
Code: [Select]
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: 3256
Re: mysql
« 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: [Select]
mysql_install_db

Let me know if you need more help.
HTH.

cse_200509

  • Member
  • *
  • Posts: 14
Re: mysql
« 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: [Select]
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: 3256
Re: mysql
« Reply #24 on: January 23, 2008, 06:48:13 am »

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

cse_200509

  • Member
  • *
  • Posts: 14
Re: mysql
« 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: 3256
Re: mysql
« 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: [Select]
mysql -h localhost -urootthat will log you into the mysql server

cse_200509

  • Member
  • *
  • Posts: 14
Re: mysql
« 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: [Select]
mysql -h localhost -urootthat will log you into the mysql server


thanx
done !
Logged

JohnB316

  • Administrator
  • Vectorian
  • *****
  • Posts: 1346
  • Registered Linux User #386728
Re: mysql
« 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]