[MDEV-4095] issues while creating db Created: 2013-01-26 Updated: 2013-01-26 Due: 2013-02-26 Resolved: 2013-01-26 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.0.0 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Mani Sundarigari | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Environment: |
I wanted to install mariadb on RHEL Server release 5.8 (Tikanga). $ uname -a |
||
| Description |
|
|
| Comments |
| Comment by Elena Stepanova [ 2013-01-26 ] |
|
Hi, Please attach your my.cnf file or paste its contents here. If you didn't create my.cnf file, and you think there shouldn't be any at all, run the install script with --no-defaults option: ./scripts/mysql_install_db --no-defaults |
| Comment by Sergei Golubchik [ 2013-01-26 ] |
|
The error message is very clear: 130126 5:16:48 [ERROR] ./bin/mysqld: unknown variable 'name=MariaDB' our config files do not have this setting, this probably comes from one of your my.cnf files that you have on your system. 'name' is not a valid configuration variable, it wouldn't work either in MySQL or in MariaDB. |
| Comment by Mani Sundarigari [ 2013-01-26 ] |
|
may i know what should i do now? |
| Comment by Mani Sundarigari [ 2013-01-26 ] |
|
$ ./scripts/mysql_install_db --no-defaults To start mysqld at boot time you have to copy PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! './bin/mysqladmin' -u root password 'new-password' Alternatively you can run: which will also give you the option of removing the test See the MariaDB Knowledgebase at http://kb.askmonty.org or the You can start the MariaDB daemon with: You can test the MariaDB daemon with mysql-test-run.pl Please report any problems with the './bin/mysqlbug' script! The latest information about MariaDB is available at http://mariadb.org/. |
| Comment by Elena Stepanova [ 2013-01-26 ] |
|
So, It worked just fine. As Sergei said above, you need to locate your my.cnf file containing the invalid 'name' option and remove it. Until you do that, you can run the server the same way ./bin/mysqld_safe --no-defaults |
| Comment by Mani Sundarigari [ 2013-01-26 ] |
|
$ ./bin/mysqld_safe --no-defaults |
| Comment by Elena Stepanova [ 2013-01-26 ] |
|
Hi Mani, Please try to read the messages that the software produces instead of just pasting them, they do make sense most of the time. This one says there is /tmp/mysql.sock which the server needs, but you don't have permissions for. If you need guidance on setting correct permissions on files, please read Linux documentation. For basic information on how to start MariaDB server, please read https://kb.askmonty.org/en/starting-and-stopping-mariadb/ (you probably need all sections). |
| Comment by Elena Stepanova [ 2013-01-26 ] |
|
Forgot to mention: please keep in mind that if you already have /tmp/mysql.sock, there is a chance that you also have a running MySQL/MariaDB server on the machine. If that's the case, you'll need to provide a unique port and socket value for the server you are trying to start, to avoid conflicts. Yo will find how to do that in the KB section by the link above. |
| Comment by Mani Sundarigari [ 2013-01-26 ] |
|
Thank You. Looks like it went through now. $ ./bin/mysqld_safe --no-defaults |
| Comment by Mani Sundarigari [ 2013-01-26 ] |
|
can you please assist me here. i have run this command ./scripts/mysql_install_db and now i want to start mysqld and list databases |