Please support VectorLinux!

Author Topic: mysql[solved]  (Read 6284 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?

M0E-lnx

  • Administrator
  • Vectorian
  • *****
  • Posts: 3208
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 »

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.

M0E-lnx

  • Administrator
  • Vectorian
  • *****
  • Posts: 3208
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 »

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>

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)
                                               

M0E-lnx

  • Administrator
  • Vectorian
  • *****
  • Posts: 3208
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 »

M0E-lnx

  • Administrator
  • Vectorian
  • *****
  • Posts: 3208
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?

M0E-lnx

  • Administrator
  • Vectorian
  • *****
  • Posts: 3208
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 !

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
VL 6.0 SOHO latest alpha on one box, VL 5.9 Lite on the other.