Søren Neigaard wrote:
>
> HS> To see if there are correct permissions check the db table ind Database
> HS> MySQL - there you find Database specififc persmissions for each user.
>
> Yes in db the homebrew user did not have any permissions, so I change
> them manually, and now it all works. But
Hy Soren,
Søren Neigaard wrote:
> I have tried to get through with this question two ties before, and
> since I'm not getting any replies, I'm starting to think that I must be
> asking the wrong question. What am I doing wrong then?
sometimes you need to choose a good subject, but i don't know
Hy,
Was something wrong with this post or is it really such a weird problem
that there is neither a solution nor anything i could do to solve it,
nor anything i could do to find out more about it?
that was the message:
I get some Errors when doing Replication on MySQL 3.23.47. And can't get
i
Jochen Kaechelin wrote:
> What licence do I need when a want to install a MySQL-Server
> in a intranet on a Linux-Box where 4 Win-Clients use it by running
> a PHP Groupware Application?
>
I'd say you can just go and use it without a fee AFAIK, but for a
judicial correct and valid answer I w
Hy All,
I get some Errors when doing Replication on MySQL 3.23.47. (I did not
upgrade because in Changelog there is no Replication-Related Bugfix
mentioned)
the Messages in error-log are:
020208 17:43:20 mysqld started
/usr/local/mysql/3.23.47/libexec/mysqld: ready for connections
020208 17:
Jeremy Zawodny wrote:
> On Sun, Jan 20, 2002 at 12:01:29AM +0100, Henning Sprang wrote:
>> [...]
>>so fra , so good. Then doing
>>
>># ssh [EMAIL PROTECTED] -L 8:localhost:3306
>>
>>
>>and connecting to port 8 on my machine with teln
Hy all,
i am just trying to tunnel a mysql client connection via ssh.
i am behind a firewall that doesn't let mysql connections through to the
outer world.
But i can do ssh to the host i want connect to. Tunneling http port 80
with the command
ssh [EMAIL PROTECTED] -L 8:localhost:80
gives
sascha mantscheff wrote:
> Ihre Nachricht vom Friday 18 January 2002 12:14:
>
>>sascha mantscheff wrote:
>>
>>>I'm not using replication, but for a test if it really works I would do
>>>some data manipulations on the master and afterwards a complete mysqldump
>>>of master and replica and diff th
sascha mantscheff wrote:
> I'm not using replication, but for a test if it really works I would do some
> data manipulations on the master and afterwards a complete mysqldump of
> master and replica and diff the result.
ok, this is an new and interesting idea, has anyone an idea how long it
Hy,
having Replication running now, I would like to know if there are ways
to test if it all _really_ works ok.
Things i know I could do:
- checking that no errors occur in the logs on master and slave
- testing some queries an see if the changes take effect on the master
and the slave in th
M. A. Alves wrote:
> On Thu, 17 Jan 2002, Henning Sprang wrote:
>
>>>So your field is of fixed length type (you hadn't told us that yet).
>>>
>>Aehm, no, it isn't! It's VARCHAR.
>>
>
> Doesn't matter: "If you assign a value to
Hy, sorry for the trouble!
i tried to do a
chown mysql:daemon -R *
in the data dir, and after that it worked.
I didn't try that before because somehow i couldn't see a connection
between differing ownerships and disfunctional tables when looking at this.
sorry,
henning
Henning Sp
Hy all,
I just try to set up Replication with two mysql databases,
i did everything like described in the Replication-Howto.
Now i get the following errors when starting the slave:
020117 18:37:55 mysqld started
Can't initialize InnoDB as 'innodb_data_file_path' is not set
/usr/sbin/mysqld-max:
Hy,
has anyone ever experienced the problem that when specifying a
program-prefix with configure, the specified prefix will be prefixed two
times, say i do
./configure --prefix=/usr/local/mysql/ --program-prefix=ga
then I get binaries like
gagamysql gagamysqladmin gagamysqlshow
and so on..
M. A. Alves wrote:
> On Thu, 17 Jan 2002, Henning Sprang wrote:
> So your field is of fixed length type (you hadn't told us that yet).
Aehm, no, it isn't! It's VARCHAR.
Sorry I overread that part, a colleague sitting next to me told me that
this behaviour is _normal_ a
M. A. Alves wrote:
> On Thu, 17 Jan 2002, Henning Sprang wrote:
>
>>... I just realized that Mysql simply "cuts" Data i want to insert
>>into a field when it is too long, without giving any warning or error
>>message. . .
>>
>
> If the fie
Hy,
I have an interesting question, I just realized that Mysql simply "cuts"
Data i want to insert into a field when it is too long, without giving
any warning or error message.
Ok, i know now that this happens and that i have to take care myself
that this doesn't happen.
But i am very curiou
Hy,
We have a web application with a mysql DB running for our clients on one
server in the Internet at a provider's place, and we want to have a copy
of the files and the database on a machine in our local network which is
accessible from outside, too, but with lower bandwith, which we only
wa
Am 21 Dec 2001 15:57:13 +0100 schrieb Carsten H. Pedersen:
>
> > I would like to know if there is a possibility to get all allowed
values
> > of an enum field out of the database.
> >
> > I know there are methods to get the field type and those give me back
> > something like "enum('value1', 'val
Hy there,
I would like to know if there is a possibility to get all allowed values
of an enum field out of the database.
I know there are methods to get the field type and those give me back
something like "enum('value1', 'value2', 'value3')", and I can parse my
possible values out of this with r
Am 20 Dec 2001 03:35:37 -0600 schrieb ROry O'Connor:
> this is an absolute newbie question - but when i try to run mysqldump with a cron
>(like with a shell script) i can't because mysqldump utility stops to ask for a
>password. how can I either embed the password or set up mysqldump to not ask
hy
Am 19 Dec 2001 13:06:30 + schrieb Matthew Darcy:
> Hi,
>
> I am not normally a fan of gui's but seeing as I am finding mysql a bit
> different from oracle I could use all the help I can get as my database may
> end up quite complicated.
>
> Are the gui's available for linux ??? are they
Am 18 Dec 2001 16:11:18 -0800 schrieb Jeremiah Jester:
> Went through these steps and resetup the tables but im still unable to set a
> new password.
>
> The command i used was:
>
> /usr/bin/mysqladmin -u root -p password mypassword
>
> I then was prompted for a password. But when it failed to
Some other details that might be of interest in this case:
- it's not a good idea to type the password at the shell prompt
(it's then in the command history)
rather type
mysqladmin -u USERNAME -p
Mysql then asks you for a password with it's own prompt
the same is for mysql client.
- mysql
Am 18 Dec 2001 14:35:07 -0800 schrieb Jeremiah Jester:
> Well it seems as though i may have mistyped my root password for mysql since
> nothing seems be working. Anybody no how to set a new root password or how
> to reset the old password in mysql? Already tried uninstalling the RPM from
> in hope
Hy,
Am 18 Dec 2001 10:50:40 -0800 schrieb Jeremiah Jester:
> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
in the default installation at the first start there is no password set
for the mysql root user.
Not
Hy,
I have a question on how to build a query.
scenario:
I have three tables,
Users:
--
user_id INT(32),
username CHAR(64)
Tasks:
--
task_id(INT32),
task_name CHAR(64)
Authorization:
--
user_id INT(32),
task_id INT(32)
some details of database design are neclected here.
27 matches
Mail list logo
