Hello,
I have a problem with mysql.
My machine is a Fedora 9 (fully updated) on an AMD Athlon XP 2800+, 3GB
RAM. SELinux is disabled.
All user except root cannot even "use" a database. All trials to access
a database result in a "MySQL server has gone away" error.
Below is the workflow, starting with an uninitialized mysql
installation, and showing the creation of a new database called JPATest,
the creation of a new user called 'jpauer' the settings of it's
privileges an it's password. The user 'jpauer' cannot login with the
specified password. Any trial to acces the new Database by the user
'jpauser' resutl in the mentioned error. The user 'root' on the other
hand can perfectly acces all databases.
Do you have any idea?
Thanks in advance
Boris
##################
Attachement: Workflow to repoduce the error:
[root@mymachine redhat]# /etc/init.d/mysqld start
MySQL-Datenbank initialisieren: Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h mymachine password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
[ OK ]
MySQL starten: [ OK ]
[root@mymachine mysql]# mysqladmin -u root password 'xxxxx';
[root@mymachine mysql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.0.51a Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database JPATest;
Query OK, 1 row affected (0.00 sec)
mysql> use JPATest;
Database changed
mysql> grant all on JPATest.* to 'jpauser' identified by 'passwort';
Query OK, 0 rows affected (0.00 sec)
mysql> quit;
Bye
[root@mymachine mysql]# mysql -u jpauser -p
Enter password:
ERROR 1045 (28000): Access denied for user 'jpauser'@'localhost' (using
password: YES)
[root@mymachine mysql]# mysql -u jpauser
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.0.51a
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use JPATest;
No connection. Trying to reconnect...
Connection id: 7
Current database: *** NONE ***
ERROR 2006 (HY000): MySQL server has gone away
mysql>
--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
Guidelines: http://fedoraproject.org/wiki/Communicate/MailingListGuidelines
