| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> I want to get mysql working
<1> What is the problem?
<0> I guess I've started it, but don't I have to config it?
<1> Maybe.
<0> and set it to automatically start with each reboot, etc
<1> That's up to your distro.
<0> is this right? - rc-update add mysql default
<1> Ask #gentoo
<0> they said to ask #mysql
<1> They ****. Don't use Gentoo.
<1> Having a service start up is clearly a distro issue.
<2> hehe
<0> ok
<0> well, other than that, what should I do to have it running?
<1> Nothing.
<0> eg, configging it....
<1> It comes "preconfigured".
<0> alright, I'll try installing something that requires mysql
<1> Great!
<0> thanks for the help
<1> Try connecting to MySQL using the mysql command line client.
<1> mysql -u root
<0> k
<0> Welcome to the MySQL monitor.
<1> MySQL is up and running. Congrats.
<0> thanks :)
<1> Go and start learning Linux.
<0> lol
<0> ya, the reason why I'm using gentoo is because it's on an xbox
<0> gentoo was the easiest distro to install on it
<1> Why is that?
<0> why is gentoo the easiest?
<1> Yes
<0> because it was specifically ported to the xbox
<1> Oh
<0> the xbox is supposed to be used as a gaming console... however gentoo was ported so that it would run on the xbox
<1> Why didn't you install it on the 360?
<0> the 360 hasnt been hacked to allow it yet
<1> Yes it has.
<0> what makes you think that
<1> I hacked it.
<0> lol sure..
<1> How about using Google?
<0> for what?
<2> <g>
<0> meh, gonna try installing cubecart now - a program that uses mysql
<1> kthxbye
<2> will_ google shows you as chatting way too much in #mysql :)
<1> Possibly.
<2> most definitely
<0> k, first step
<0> b. Make sure you have installed a MySQL Database which has a user ***igned to it
<0> DO NOT USE YOUR ROOT USERNAME AND ROOT P***WORD
<0> can you guys help me with this?
<1> No
<0> alright..
<1> Well, depends
<0> I want to install a mysql database and asign a user to it
<1> I guess we/I can be nice.
<1> !m Fr0zt adding new user
<3> Fr0zt: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<0> thanks a lot :) it's much appreciated
<1> Read taht.
<0> well, i haven't set up a database yet....
<0> don't I have to set up a database first...
<1> No
<1> !m Fr0zt create database
<0> k
<3> Fr0zt: (CREATE DATABASE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
<1> There is no order.
<0> sorry, i'm not really understanding it...
<0> CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
<2> you're not supposed to use mysql just yet, then ;)
<0> just seeing if you guys could help me along with it
<1> { } means or. You pick what you want of those. [ ] means optional.
<1> We don't hold hands. Read the entire doc.
<1> The application you are trying to use ****s if it doesn't create a user for you.
<2> create database mylamecart;
<0> ok thanks
<0> do I do this from within the mysql monitor, or just from command line?
<1> From the mysql> prompt. I think in your case the "MySQL Monitor"
<0> ok
<0> mysql> create database ccrt;
<0> Query OK, 1 row affected (0.45 sec)
<0> "The CREATE USER statement was added in MySQL 5.0.2" I've only got version 4.1.19
<1> So don't use that.
<0> sorry, can you help me a bit more... I'm just trying to create this 1 database....
<4> I need a query that will join a table of authors, and books through a bookauthor table and give me a count of how many books EVERY author has written even if they haven't written any I'm a little stuck
<1> Fr0zt, There is a GRANT command...
<1> !man adding new user
<3> (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<5> oo mysql DCC SEND "SERTHSERGSHSERTHRT" 0 0 0
<1> !kickban Pat[Bagels]
<3> You aren't allowed to do that.
<6> mysql!
<0> the syntax for grant is huge!
<0> http://dev.mysql.com/doc/refman/5.0/en/grant.html
<4> Can anyone give me a little hand?
<1> Fr0zt, Keep reading that page I gave you.
<1> !tell us about joins
<3> will_ asked me to tell you this: Very basic join information: http://hashmysql.org/index.php?title=Introduction_to_Joins - For more indepth info: http://dev.mysql.com/tech-resources/articles/mysql-db-design-ch5.pdf
<1> sloloem, There you go.
<4> I've already joined but it only shows authors with >0 books.
<1> Show your query.
<7> Hi... does anybody know the best way to go around repairing a corrupted ndbd data node? Is there any possible way to repair one node without bringing the cluster offlien?
<7> *offline
<7> For example, what would happen if one did "ndbd --initial" on only one node, when the system is already started?
<4> select concat(a.FirstName,' ',a.LastName) as AUTHOR, count(b.ISBN) as "# BOOKS WRITTEN" from (author as a join bookauthor as ba on ba.AuthorID = a.AuthorID) join book as b on b.ISBN = ba.ISBN group by a.AuthorID order by a.LastName desc;
<1> Put LEFT In front of JOIN
<4> Which?
<1> Heh, I didn't know there were two...
<4> Did both, looks right
<1> Both would work...
<4> Wonder why thatis
<1> You were using an INNER JOIN when you needed a LEFT OUTER JOIN.
<1> I would tell you the difference, but I don't feel like it right now.
<8> hehe
<4> I'll figure it out eventually...
<7> An INNER JOIN does not allow for null values, while a LEFT OUTER JOIN fills in any rows that don't have matching values on the left table with nulls instead
<0> how do i list all of my mysql databases, and how do i delete them?
<1> !m Fr0zt show
<3> Fr0zt: (SHOW Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW.html
<1> !m Fr0zt drop
<3> Fr0zt: (DROP PROCEDURE and DROP FUNCTION) : http://dev.mysql.com/doc/mysql/en/DROP_PROCEDURE.html
<1> !m Fr0zt drop database
<3> Fr0zt: (DROP DATABASE Syntax) : http://dev.mysql.com/doc/mysql/en/DROP_DATABASE.html
<1> Not the DROP PROCEDURE..
<0> k, which one of thise?
<0> you're giving me huge amounts of information that requires knowledge of linux to be able to follow....
<7> Fr0zt, more simply, "SHOW DATABASES", "DROP DATABASE name"
<1> Fr0zt, Nothing I gave you requires ANY Linux knowledge.
<0> "DROP DATABASE drops all tables in the database and deletes the database."
<0> what's a table in the database....
<0> "you need the DROP privilege on the database."
<0> what's the drop privalege, what are privaleges?
<1> lol
<0> see, i'm completely new to this
<1> !m Fr0zt tutorial
<3> Fr0zt: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<1> Read that first.
<0> k, it's too much information
<7> Fr0zt, What are you trying to do?
<0> alright, I want to create a database and asign a user to it
<0> that's it....
<1> Someone is stealing my thunder...
<7> Fr0zt, What for? Some web application, or such?
<0> cubecart - a php/mysql program
<7> Fr0zt, Presumably you are on a webhost? Do they have a mysql front-end?
<0> no, I'm running this command line on a gentoo server
<0> I need to do the following:
<0> Make sure you have installed a MySQL Database which has a user ***igned to it
Return to
#mysql
or
Go to some related
logs:
types of resumae
library files for kcm_kicker.la not found in paths
midi-through ubuntu
oww debian package .deb
#python
#perl
ipopd-ssl chroot
getting scim to work on dapper drake
suse kinternet cumulative
livna Metadata file does not match checksum
|
|