amarok乱码_通过大量音乐收藏加快Amarok的速度
amarok乱码
Amarok is a wonderful application for managing and playing your music collection, but the default settings aren’t optimized for speed when it comes to large collections of music. The problems are especially noticeable while trying to use the search box.
Amarok是用于管理和播放音乐收藏的出色应用程序，但是对于大型音乐收藏，默认设置并未针对速度进行优化。 在尝试使用搜索框时，这些问题尤其明显。
The problem is that the default embedded database uses sqlite to store the collection information, which doesn’t scale quite as well as a dedicated database such as MySQL… so we’ll switch to use that instead.
问题是默认的嵌入式数据库使用sqlite来存储集合信息，而后者不能像MySQL这样的专用数据库那样扩展，因此我们将改用它。
Configuring MySQL for Amarok
为Amarok配置MySQL
These instructions assume that you don’t already have MySQL installed. If you are already using it, then just skip the first couple of steps.
这些说明假定您尚未安装MySQL。 如果您已经在使用它，则只需跳过前几个步骤。
Assuming you are using Ubuntu, run this command from a terminal to install the MySQL server and client on your system:
假设您正在使用Ubuntu，请从终端运行以下命令以在系统上安装MySQL服务器和客户端：
sudo apt-get install mysql-client mysql-server
须藤apt-get install mysql-client mysql-server
For security’s sake, you should probably set a root password for your MySQL server using this command:
为了安全起见，您可能应该使用以下命令为MySQL服务器设置root密码：
sudo mysqladmin -u root password “mynewpassword”
sudo mysqladmin -u root密码“ mynewpassword”
You can use the “flush privileges” command or just restart MySQL:
您可以使用“ flush privileges”命令或仅重新启动MySQL：
sudo /etc/init.d/mysql restart
sudo /etc/init.d/mysql重新启动
Next we’ll use the mysqladmin command to create a database for Amarok to use:
接下来，我们将使用mysqladmin命令创建一个数据库，供Amarok使用：
sudo mysqladmin -u root -pMyRootPassword create amarokdb
须藤mysqladmin -u root -pMyRootPassword创建amarokdb
The final command line step will setup the user account for Amarok in MySQL. Make sure to use a different password here.
最后的命令行步骤将为MySQL中的Amarok设置用户帐户。 确保在此处使用其他密码。
mysql -u root -pMyRootPassword
mysql -u root -pMyRootPassword
> GRANT ALL ON amarokdb.* TO [email protected] IDENTIFIED BY ‘amarokpassword’;
>将所有内容授予amarokdb。*至amarok @ localhost，由'amarokpassword'标识；
> FLUSH PRIVILEGES;
>冲洗特权；
Configuring Amarok
配置Amarok
Open the Amarok configuration dialog via the tools menu and then pick the Collection icon on the left.
通过工具菜单打开Amarok配置对话框，然后选择左侧的Collection图标。
Change the drop-down to MySQL, and then enter in your details:
将下拉列表更改为MySQL，然后输入您的详细信息：
- Hostname: localhost 主机名：localhost
- Database: amarokdb 数据库：amarokdb
- Username: amarok 用户名：amarok
- Password: password from step above 密码：以上步骤的密码
Close out of the dialog, and then you’ll have to rescan your collection to move everything into MySQL, which might take a little while the first time.
关闭对话框，然后必须重新扫描您的集合才能将所有内容移入MySQL，这可能需要一段时间才能完成。
Enjoy the speedy searching!
享受快速搜索！
翻译自: https://www.howtogeek.com/howto/linux/speed-up-amarok-with-large-music-collections/
amarok乱码