W4F-Server:/usr/bin # mysql_setpermission
Password for user to connect to MySQL:
install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.6.0/i586-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.10: cannot load shared object file: No such file or directory at /usr/lib/perl5/5.6.0/i586-linux/DynaLoader.pm line 200, <STDIN> line 1.
at (eval 7) line 3
Compilation failed in require at (eval 7) line 3, <STDIN> line 1.
Perhaps a required shared library or dll isn't installed where expected
at /usr/bin/mysql_setpermission line 65



what is this?

You need to have perl-DBI and perl-DBD-MySQL installed in order to use this functionality - like documented in the MySQL installation file ...

Check http://www.mysql.com/doc/en/DBI_with_DBD.html for more information!

ok thanks.

I need help...

I have create a user

GRANT SELECT,UPDATE,DELETE,INSERT ON DB.* TO user1@'%' IDENTIFIED BY 'passuser'

But when i try to connect it :

mysql -h 172.16.1.222 -u user1 -ppassuser


error accur :
ERROR 1045: Access denied for user: 'user1@comserver' (Using password: YES)

When i try this at Mandrake 9.0 everything is OK...
why???

Try logging in the first time with this command:

mysql -h 172.16.1.222 -u user1 -p

then quit mysql and try the following, and see if it works:

mysql -h 172.16.1.222 -u user1 -ppassuser

I guess you have to login once interactively, and then you can enter from the command line after that...just a guess though.

Ryan

Ok. Mysql service is now online. But how do I start now?

Server: localhost
user: mysql?
password: ?

How to create users for mysql?

Yea! i gotit. Thanks for your help

I still have the same problem

Luc..
How u create a user for MySQL???

If you want to create a user called XXX with a password YYY ,with privileges AAA BBB on the tables T1 and T2

GRANT AAA,BBB
ON dbase_name.T1,dbase_name.T2
TO XXX@host_name
IDENTIFIED BY "YYY";

I have create a user

GRANT SELECT,UPDATE,DELETE,INSERT ON DB.* TO user1@'%' IDENTIFIED BY 'passuser'

But when i try to connect it :

mysql -h 172.16.1.222 -u user1 -ppassuser


error accur :
ERROR 1045: Access denied for user: 'user1@comserver' (Using password: YES)

When i try this at Mandrake 9.0 everything is OK...
why???

How to install mysql:

Download the following file:
ftp://filepile.tiscali.de/mirror/mys...3.23.52.tar.gz

create the dir /usr/local/src/lamps

then do:

cd /usr/local/src/lamps
for i in `ls *.gz`; do tar zxf $i; done;

cd /usr/local/src/lamps/mysql-3.23.52/
./configure --prefix=/usr/local/mysql/3.23.52 \
--localstatedir=/home/mysql/data
make
make install
ln -s /usr/local/mysql/3.23.52 /usr/local/mysql/current

mkdir /home/mysql /home/mysql/data
scripts/mysql_install_db
/usr/local/mysql/current/bin/safe_mysqld &
/usr/local/mysql/current/bin/mysqladmin -u root password 'xxxxxx'

if this doesnt work try:
/usr/sbin/adduser mysql
chown -R mysql:mysql /home/mysql
/usr/local/mysql/current/bin/safe_mysqld &
/usr/local/mysql/current/bin/mysqladmin -u root password 'geheim'


cp support-files/mysql.server /etc/rc.d/init.d
chmod 744 /etc/rc.d/init.d/mysql.server
cd /etc/rc.d/rc2.d
ln -s ../init.d/mysql.server S20mysql.server
ln -s ../init.d/mysql.server K20mysql.server
cd /etc/rc.d/rc3.d
ln -s ../init.d/mysql.server S20mysql.server
ln -s ../init.d/mysql.server K20mysql.server

ln -s /usr/local/mysql/current/bin/mysql \
/usr/local/bin/mysql
ln -s /usr/local/mysql/current/bin/mysqladmin \
/usr/local/bin/mysqladmin
ln -s /usr/local/mysql/current/bin/mysqldump \
/usr/local/bin/mysqldump
ln -s /usr/local/mysql/current/bin/mysqlshow \
/usr/local/bin/mysqlshow


then mysql should work...

syzuhdi

Try using mysqladmin to create user.

I think to login you need to use mysqladmin to create user accoutn

Grant only gives the user permission to access the database but not administration.

I may be wrong.

Let me know if this works.

Newbie too.

esael...
How to use mysqladmin...please give mesome examples..
Thanx

Syzuhdi,

Sorry wrong info. I tried your method

GRANT SELECT,UPDATE,DELETE,INSERT ON DB.* TO user1@'%' IDENTIFIED BY 'passuser'

But when i try to connect it :

mysql -h 172.16.1.222 -u user1 -ppassuser

and it worked for me.

How abt try granting all privileges.... did you try flush privileges?