mysql[solved]

[cse_200509]

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]

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

[cse_200509]

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]

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

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_

[cse_200509]

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

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>

[kidd]

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

[cse_200509]

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

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)
                                               

[M0E-lnx]

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.

[cse_200509]

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?

[M0E-lnx]

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

[cse_200509]

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]

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

[cse_200509]

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 !

[JohnB316]

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