MySQL has gone away

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux